I got a Table having 10 ntext fields and around 25 int/varchar fileds. I
face an issue of loosing data occasionally.. I using Update Statement to
update all the fileds.
Also I have Free textbox editor for all ntext fiels which generates embeded

Please I would like to know how I can configure auditing on Sql Server
2000
in such a way that it would log which users logged on, what
modifications they made to the

We are getting ready to move from sql server 2000 to 2005 (currently
on test). In addition to many things we have a linked server pointing
to of all things Cache (also known as Crapche). On our 2000 box we
have a linked server pointed to Cache that has worked fine for many

I have various tables and stored procedures that I need to port to
another server.  So I have to script each one out to a file or to the
clipboard.  Is there any way to script each one so that each new one
appends to a file instead of creating a new file every time?  When I

I'm using the SQL Server Agent Output files.
I'm calling a stored procedure that outputs some Chinese characters.
When I execute it in Management Studio it looks good
When I execute it in the SQL Server Agent and is using an output file the

Gurus,
I am trying to open SQL Management Studio 2005, wait 60 seconds, then press
the ALT + C key.  The reason for this is Microsoft reduced the functionality
of SQL 2005 (those darn Microsoft programmers!!) whereby one has to manually

Key Range Locking  
(also called Next-Key Locking)
There is a way to disable the Key Range Locking mechanism under MS SQL
Server 2005 (or 2008) ?

I have got problem while I install Microsoft SQL Server 2000 on
Microsoft Windows XP SP 2.
Below is the error message:
The specified file cannot be opened as read-only. Ensure the source

[sql 2005, RTM version (1399) + SP2 ]; Config Manager does not show Sql
seerver, Agent, FullText Search, though they are running.The only one listed
is SSIS.
How to fix?

What is a good number of DBAs to administer x no. of instances or databases
? Is there a good measure out there. I know the answer could be..it
depends.. and depends on their skills, availability of the systems, tools,
etc..

I am just getting started with CLR in SQL Server 2005.
Could someone please tell me how to find all objects that reference a CLR
assembly?
Thanks,

I have client who uses SQL 2000, and who wants to adjust the user database
maintenance plan so as to remove backup files older than a certain age.
However in both the Complete Backup and the Transaction Log Backup settings
it is not possible to select the unit (minutes, hours, ...

I am having a major performance issues with Microsoft SQL 2005 x64 and  
Windows Server 2003 x64.  
A single query on the same hardware was taking about 20 seconds it took now
more than 211 seconds after installing the windows server 2003 x64 and SQL

This is dealing with SQL server 2005.
I have a large sql dump and when I try to import it i get an error
that says "The operation could not be completed. Not enough storage is
available to process this command."

I tried creating this account but when i send test mail, it gives me this
error :-
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 6 (2008-05-21T17:28:16). Exception