After the hotfix was applied, we're currently at 8.00.2232.

Thanks...Chris

There is no one hotfix; it depends. The error is caused by several different reasons, so there are several different hotfixes. Besides, you can't obtain a hotfix 'til...

We have SQL 2K SP4 installed and we encountered this problem with the machine locking up and becoming unresponsive. My initial research said to contact MS and obtain a...

Yes, all of the troubleshooting steps described above are correct.

No, there are no groups that have a "Deny login" defined, in SQL.  Even so, the account is a member of...

The error message that I posted earlier is the full error message.  It is a Windows login.  Thanks.

Chris

Well, I deleted the log-in and then re-added it, giving it a default database of master, but that didn't work either.  Any other ideas?  Thanks.

Chris

Steve, I don't know why it didn't click until you wrote it just there, even though I had read it.  This situation is probably due to the fact that a...

Yes, the log-in is added to the server.  The message that I get is below.

"Unable to connect to server ...

Server: Msg 18456, Level 16, State 1

[Microsoft][ODBC SQL Server Driver][SQL Server]Login...

Cool beans.  Thanks for the input.

And everyone agrees that the system database data and log files should be separate, as well?  Like many others here, I never thought to do this.  Thanks.

Chris

Colin, the 5 arrays hold OS, SQL Binaries, Data, Log, and TempDB, respectively?  With backups, another is needed, huh?  So, 6 different drive arrays, huh?  Thanks.

Chris

It also depends on what data you are trying to get at...whether or not you'll use a left outer join, a right outer join, an inner join, a cross join,...

The same is true for hyperthreaded processors.  I guess the same also holds true if the processors are dual-cored and hyperthreaded processors, huh?  Am I right?  Thanks.

Chris

Hmm...thanks for the info.

I'm writing up my company's DR strategy now, so this is definitely helpful.

Anyone have any templates for a DR doc?  I found some on http://www.sqlperformance.com, but...

Sugesh, so the only way to roll back to regular log-shipping with the initial primary being primary again is to set-up log-shipping again?  Or did I misunderstand?  Thanks.

Chris