I inherited a SQL 2005 server. Initial installation has the sytem DBs on the O/S partition. So were all the user DBs. I was able to move all the user DBs to another partition and want to do this with the system DBs but have been running into problems. I have read everywhere that talks about using SQL...

I'm trying to debug SQL Server 2005 stored procedures with Visual Studio 2005. According to Microsoft specifications the user of the connection has to be sysadmin. Doing this the debug works correctly, but I want to debug without have administration permissions or without be sysadmin. Is it possible...

The place where I work has very recently adopted a new computer system that utilizes SQL Server 2005. The most significant problem so far has been assisting users who cannot access data because it is locked by another user. Is there any way to identify the specific user who is locking a record? I have...

Apart from the suggestions given above, this link http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx is worth taking a look