First change the recovery model to SIMPLE. If you aren't going to run transaction log backups then don't set recovery to FULL. Next, use the command BACKUP...

Tolerance and acceptance that others may not share your point of view would be nice.

Merry Christmas/Happy Holidays to all

In terms of material stuff I'm pretty satisfied although noise-cancelling headphones might help me concentrate in this cube-world.

In other ideas I've decided to give...

ok... but you are not writing the cursor. Why does the existance of a cursor matter?

To avoid use something like:

DECLARE @objName varchar(50)

DECLARE @cmd nvarchar(250)

SET@objName = ''

WHILE@objName IS NOT...

Sure see BOL for more info on sp_MSforeachdb

Here is a sample:

EXEC sp_MSforeachdb "USE ? IF db_name() NOT IN ('master', 'tempdb', 'model', 'msdb' )

begin select db_name() EXEC sp_updatestats end...

You do not need to apply any Service Packs before migrating to SQL 2005. SQL 2005 is a new install and your existing databases will migrate whether they are...

Thanks but as I mentioned I have switched this feature on. If I hadn't switched this on I would have got the error message:

Msg 15281, Level 16, State 1,...

Its too bad you don't have a test environment. I suggest you create one especially for SP4.

For some tips what to look for see

http://sqlserver2000.databases.aspfaq.com/what-do-i-need-to-know-about-sql-server-2000-sp4.html

Some items on forums...

xp_cmdshell can be used to execute DOS commands. SO assuming you have zip software installed that has a command line version (like Winzip or 7-Zip and I'm sure others...

Everytime I see a problem like this (we are using a maintenance plan and get this error) I add it to my list of why I never use maintenance...

Great idea. I would like to further suggest that the daily newsletter no longer provide the answer to yesterdays question. It might lead to some odd behavior for...

Is this production? I can understand having multiple versions in test (development) or UAT but I've never seen multiple versions in production. If only one of the databases...

You may be able to avoid using the port number if you upgrade MDAC to 2.6 or later. See http://support.microsoft.com/kb/265808 for more info

You are correct they are not encrypted. I know Red Gate's SQL backup can encrypt if you want. I assume other 3rd party backup products could also do...

If your SQL Server is on domain A and you authenticate to domain B on your workstation, you should be able to connect to the SQL Server if there is...