SQL 2005 is not due that soon and SQL 2000 is fairly mature

It'll be more expensive than SQL 2000 and I'd wait until the first service pack at least before...

EXEC sp_detach_db 'tempdb'

gives

Server: Msg 7940, Level 16, State 1, Line 1

System databases master, model, msdb, and tempdb cannot be detached.

Unless SQL had trace flag 3608 (from memory, and that's for...

Does teh query use an indexed view? This will be treated differently...

.Connect = "ODBC;DSN=SiteMaster;Description=SiteMaster" _

& ";UID=passthru;PWD=passthru;DATABASE=sitemaster" _

& ";Network=DBMSSOCN;Address=sqlvirtsrv,1433"

.ReturnsRecords = True

Here you'ce specified a DSN (in teh registry I guess) which will be overridden by the "Address = param"

Also, what is the...

A dedicated SQL Server is best using all the RAM it wants.

If you're running server side applications such as IIS with SQL as well, then what may have happened is...

See "Security Account Delegation" in BOL for the full story without impersonation as such

It also happens if your NT group or user has been renamed.

One of our 3rd party apps requires the domain user as a login eg DOMAIN\InitialSurname

On marriage, we have to...

Depending on the politics of the situation...

Can you increase the sa password length or change it regularly?

A long enough password will not be cracked before its time to change it...

The named pipes issue happens because a server listens on

"\\LIVE1\pipe\sql\query"

I tried and failed to get (my equivalent) DR1 to do the same thing.

If your clients are XP or have...

use sp_setnetname to modify the datasource property of sysservers. You don;t have to hack the system tables.

Our linked servers are all "virtual" - so our DR server is called "SPARESERVER"...

If XACT_ABORT is set then the batch aborts, rather than the error being trapped, that sounds like what's happening here.

In this case, nothing, because in the first the UPDATE statement is a transaction itself.

No, you only need explicit begin and commit if you have a mult-statement "unit of work"

Eg

SET...

xp_smtp_sendmail?

Where did this come from... aint a standard object

Oddly enough (or not...) the archiving routine is for a 3rd party app and it has "SELECT INTO...", I've no control over the code.

I trawled google for stuff on SQL...

Not always poor SQL...

If your CPUs are hyperthreaded (Xeon 2Ghz+, top end P4 etc) then SQL will parallel across all CPUs - physical and logical, when it shouldn't really.

HTT is...