see the below link to help you:

http://msdn.microsoft.com/en-us/library/ms191450(SQL.90).aspx

check the syslanguages table in master database.

use some trace options in SQL Server Service. For info. see SQL BOL.

UNIQUE IDENTIFIER is best for replication purpose also, for more info see SQL BOL.

use horizontal partition of the table, for more information see SQL BOL. It is good for one of the best performance.

you can get the information based on trace file or log file. see more information related to fn_trace_gettable in SQL BOL.

add "go" command after each bulk insert statement.

Manually shirk DB.

Don't enable Auto Shrik DB, it causes performance issues.

check the SQL Server Surface area configuration (Yukon / SQL 2005) and enable relevant options and also check the TCP/IP port configuration.

try like the following:

EXEC sp_detach_db @dbname = 'pubs'

EXEC sp_attach_single_file_db @dbname = 'pubs',

@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'

if still error occurs, just create new file in data...

navigate the following URL's you will get the answer:

Code:

------

Needed to Set NOCOUNT ON and change

sp_configure "user options", 512

to

sp_configure "user options", 0

URL's:

------

http://support.microsoft.com/kb/195491

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic10693.aspx

need complete information about your query.

try like:

select * from dbo.ContractHistory with (nolock) (index = IX_ContractHistory)

where eoddate between '20080902' and '20080903' and

(action = 'delete' or isnull (action, '') = '')

check the SQL Server Surface Area Configuration. and enable relevant options.

SQL 2000: select * from master..sysmessages;

SQL 2005: select * from master.sys.messages;