Silly question ... what is VNC and RDC ???

Heres a the extracted code that you requested:

declare @startup_account nvarchar(100)

execute master.dbo.xp_regread N'HKEY_LOCAL_MACHINE',

    N'SYSTEM\CurrentControlSet\Services\SQLServerAgent',

    N'ObjectName',

    @startup_account output,

    N'no_output'

select @startup_account

This was taken from the SP that Buck mentioned earlier in the post. This works for a 'default'...

Changing the underlying disk arrangement (say RAID 1 to RAID 5) has no bearing on whether or not things 'show up' in EM. If somehow you 'lost' the files for...

SET RANT_MODE ON

GO

" ... Safe and Secure, and is mainly linking to their spyware and malicious software tools ... "

In particular their "malicious software tools" - ?!?!?

Any vendor that excludes...

OK, other computers can connect ... so it's just your computer then. Got it. Have you tried a connection from the ODBC connection manager ? Have you tried re-installing the...

Is SQL2K 'standard' or 'enterprise' ? If it's 'standard' then I cannot see how it can address more than 2 Gb (actually only use 1.6 to 1.8 Gb) ...

The minimum anmount of memory for a SQL Server all depends ... at out site we use 4 Gb minimum. 2 Gb for the OS and 2 Gb for SQL...

SPID 1 is the 'lazy writer' - a system, and non-killable process. It sounds as if you need to issue the following conmmands prior to your detach:

use your_database

go

checkpoint

go

use master

go

exec sp_detach...

It sounds more like an Oracle 'export' ... so 'tweaking' it a bit and executing in QA should punch your ticket !

The '818' indicates that hotfix 818 was applied. I've both standard and enterprise servers just like that. Now whether hotfix 818 was applied to SP3 or SP3a is another story.

What is the time of the first entry in the errorlog to the last in the errorlog at startup ?

I ask because it varies from system to system ...

Expensive yes. But what is the cost of replacing your data ? Everywhere I've worked in the last 15 years has imlpemented one or more SANs. EMC is the oldest...

If you are conecting via a short servername try connecting via the fully qualified domain name. If this does not work try conencting IP address. If IP address works, then...

Can you execute a TSQL backup command from QA ?

We use MOM as well. However, MOM is only polling about once every 15-30 minutes (so you have a window when things could be down and you are not aware)...