hi to all,
there is a way to export my databases in sql format(data dump?) ?
i don't need to export it like bck.
thank a lot for the answer

    Hope you can help me with this. I am really stuck. I need to
concatenate 2 variables of type text (or ntext) in SQL Server 2005.
    Problem is though - I don't know how to do it.
    Can anyone help me please? Would greatly appreciate any assistance/

How can I determine what type of license (CAL or processor based licenses)
are installed per server?

I have this data:
id             GroupId             DDate                   Value
1                        1            7/31/2008                     5
2                        1            7/31/2008                     6

Hi SQL Gurus,
Is it true that everytime we run a query there will be some(at least one)
I/O (Read/write) process on the server?
Is data cached or only the execution plan cached?

About 6 months ago we have purchased and installed a SQL SERVER 2005
Developer license on a server. Now the same box needs to be converted to a
Production Box, and the we purchased a SQL SERER 2005 Standard License to put
on the same server.

How to script all objects in sql 2000 without data?
thanks,
Sarah

Can someone tell me if SQL 2005 SP2 is stable for a production environment on Windows 2008?  We have received mixed information from a consultant and want to know for certain whether Windows 2008 is ready for SQL 2005.  Any articles / experiences would be appreciated.
Thank-you,

Can I limit the amount of memory SQL 2005 uses?
I have 4GB in my server and sqlservr.exe uses between 3gb and 3.5gb?
Thanks

[also posted in microsoft.public.sqlserver.setup newsgroup]
I need some more help.
I have uninstalled & reinstalled SQL Server 2005 5 times now and keep
getting stuck at the same point.  During setup I use a Domain User account

I am having an issue when using Linked-Server. When running a query
from ServerA (sql 2000) pulling from ServerB(sql 2000) and dump the
results into a temp table I don't get any errors. The issue is that
when run on ServerB I get a conversion error. So, what appears to be

Suppose I have a table of numbers.  I want to display that table, but
I also want to display the sum of the number in each column as the
last row of the table.  Can I do that?  I know I can do a 'group by'
with aggregate functions, but in this case I wouldn't want to group,

Every night the sevices (SQLEXPRESS) turns off.  A restart in the mornigs and
it works fine all day but same problem the next day.  All has been working
fine for the last couple of years now this.  Installed on Win Server 2003 Std.

My impression is that SQL Server always read/writes disk data in 8K pages.
Thus, when I format a hard drive to be used for SQL Server data files, I use
8192 as the cluster size, assuming this will benefit performance.  Is this a
justified approach, or are there other ...

For example I want to get salary from Customers table based on CustomerID.
I can create a Stored procedure called GetCustomerSalary with CustomerID as
parameter
OR