Check this out.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;836734

The reason your log file grew to 2 GB might be that there was a huge transaction which was going on which resulted in the log file to be increased....

Check this out.

http://vyaskn.tripod.com/moving_sql_server.htm

Check the article below and verify MSDTC to be running. Also try testing using dtcping.exe

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306843

When you insert data using insert into, a null value is submitted for the columns which are not specified in the list of columns. Employee column in EM table might...

You can use the command below. Specify the instancename for the /sqlserver parameter.

C:\Progra~1\Tivoli\TSM\TDPSql\tdpsqlc backup master full /sqlauth=int /tsmoptfile=C:\Progra~1\Tivoli\TSM\TDPSql\dsm.opt /sqlserver=servername /logfile=C:\Progra~1\Tivoli\TSM\TDPSql\sqllog_full_System.log

If you use GUI, change the value of parameter...

Change the script to

restore database BSISUITE from disk = 'c:\BSISuite_db_200412011801.bak'

WITH MOVE 'Logical_datafile_name' TO 'c:\Program FIles\Microsoft SQL Server\MSSQL\data\BSISuite.mdf',

MOVE 'Logical_logfile_name' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\data\BSISuite_log.ldf' , REPLACE

As steve suggested,...

BOL says

"Creating a unique index instead of non-unique on the same combination of columns provides additional information for the query optimizer; therefore, creating a unique index is preferred. "

Check this article. Describes about installing Analysis service on Windows 2000/2003 cluster.

http://support.microsoft.com/?kbid=308023

I believe one of the reason why oracle dba's do not like sql server for VLDB's is the locking behavior. As you know that when a user is updating data,...

We capture perfmon data for Active/Passive clusters. For active/active, the only issue i can think about is no. of connection if you have both instances running on the same node....

Check this article. Has some good explaination.

http://www.sql-server-performance.com/at_sql_locking.asp

you can also use sp_add_job

The script below looks for references to any variable in all storedprocedures. You can save the file as .vbs and pass parameters next to it and execute it from command...

You can use the script below. Save it as a .vbs file. It gives you the username and its permissions. You can edit it to include other roles also. It...