Maybe it is my interpretation but this kb bug fix is only for backup jobs that are password protected. Not standard backups..... again, maybe it is just the way I...

My only problem with more and smaller service packs is that all I will be doing is implementing service packs OR have a handful of SQL Servers that are so...

Unbelievable !!!!   That was it.... THANKS A MILLION !   Wow... . I looked at the properties before but I must have missed that....

  Also, document what options you take when you install SQL Server. For instance, the path to the data files and binaries if it is different than the install default....

An in-place upgrade simply is like if you had a PC with Win2000 and upgrade it to XP. So, if you have SQL 2000 running and all of a sudden...

I don't think piling up tons of nuclear waste to power our power consuming electronics is the answer considering they stay radio active for hundreds of centuries.

  The time it takes to apply the SP will vary. On server speed, I/O etc AND if you have no SP, versus SP1, SP2, SP3. The reason is that...

Yep, SQL Server will grab as much memory as it can. That is why SQL Server (unless this is a very small departmental type app) should be a standalone database...

Yep, SQL Server will grab as much memory as it can. That is why SQL Server (unless this is a very small departmental type app) should be a standalone database...

 There are most certainly strong arguments for both sides. Personally, I think neucular is not the way to go. To me how to dispose of the waste is a big...

We 'used' to have a VMWare SQL Server production here. We had no choice as the old server was dying and was out of drive space and there was no...

I cannot agree with you more. There are quite a few basic DBA tasks in 2000 that were very easy, quick and simple and in 2005 are time consuming and...

I am not sure but I think there is an option somewhere to disable foreign keys.... try researching that route...

Yep, I found this as well. It IS a big deal if you have backups from previous days and after the next backup of the db all of your past...

No, I had all of the SQL Services shutdown.