Easiest option would be to mirror your databases to another server, running SQL 2005; point any applications to the new server, and run your live environment from that server temporarily...

I found this really helpful: http://www.mssqltips.com/tip.asp?tip=1687

I was puzzled about this too, but I think what's happening is that the proc is being cached, but the statement calling the proc isn't.

I created a simple...

May seem like a stupid question, but is anything actually not working, or are you just getting the error in the logs? Looking around, this seems to be...

This might help: http://support.microsoft.com/kb/2001270

The thing that I've found the biggest concern is the network speed and reliability. The set up I work with is much smaller than...

Sorry - just re-read the error! Ignore that suggestion!

The reports in the dashboard use the 2005 DMVs, so it wouldn't work with a SQL 2000 server (and most wouldn't work against a compatility 80 database either, I'd imagine).

Results are also logged to the SQL error log, whenever checkdb is run.

This might help:

http://blogs.msdn.com/sqlblog/archive/2006/10/06/MSDTC-and-SQL-Server-on-a-cluster.aspx

Not mandatory but highly recommended...

Can't see the wood for the trees sometimes. Thanks, I'll try that. If restarting the agent fixes the issue, then would you assume that whatever's causing the problem...

Not a free white paper I'm afraid. The best source I've found for information about indexing has been Kalen Delaney's book Inside SQL Server; Itzik Ben-Gan's Inside TSQL Querying...

Yes, but at the point that we started looking at granting access to various registry keys, we decided that discretion was the better part of valour and went back to...

Running as local admin isn't the preferred option in this case - SQL needs to be running with minimal privileges (no problems doing this in Windows 2003). I'm not...

Hi,

If you have backups made with a product like litespeed, yes, you can 'restore' (that is, script out) stored procs, functions etc from a backup file. With native SQL...

The only possible answers to this are 'yes' and 'no'. Something is either the default or it isn't.