If the master db is damaged SQL Server will not start so you can not restore the master db.

I did not know they sunsetted the rebuildm utility from 2000.

No, we are not using any linked servers.

It was my understanding that Microsoft does NOT support SQL Server running on VMWARE. Unfortunately I learned this after we had two test servers up and running on VMWARE. We...

I have one production ID that has these specific rights to install and run the MSSQLServer and SQLAgent services:

Act as Part of the Operating System = SeTcbPrivilege

Bypass Traverse Checking =...

The question I would have is though how does having a different Service Pack on different instances effect Integration Services ? If you have alot of packages for both instances...

Out of our 20 production SQL Servers only three are SQL 2005. I have been holding off going to 2005 because i believe it is somewhat buggy (I have seen...

I would hope at bare minimum they would release a SP3 that has ALL of the hotfixes after SP2 rolled up.

Great ! Thanks for the link to to patch for SP2. I have not heard when SP3 will be out. I know there are alot of hotfixes that...

Question: I thought that Microsofts stance on Service packs and CU was that you apply the latest SP but ONLY apply a CU if you are experiencing a specific...

sp_helpusers is another one that I use.

I ended up deinstalling and reinstalling and then it was OK. THanks for your help !

I agree. Being a DBA I have a wireless laptop and check email and do some work at home plus being on-call 24 X 7 365. Personally I'd like it...

Yep, that was it... thanks a million.

I had a PC store by us build us a new PC with Vista. After it was all done and delivered I found that they put 64 bit Vista on....

Thanks for all of the feedback.

We ended up figuring out that the application on this server was in a loop sucking up almost 100% of the CPU most of...