Another thing to do is set your database recovery mode to SIMPLE.

-SQLBill

Sometimes the problem can be due to the incorrect MDAC version. Try downloading the latest MDAC version from Microsoft and installing that in the problem computers.

If you want to check...

First of all, neither of those is the MDAC version nor SQL Server version.

You can find the SQL Server version by using SELECT @@VERSION.

On Microsoft's web site, find Component...

Vincent,

As I said in my post, it was a very specific issue.

1. You had to be running SQL Server 2000 Enterprise Edition

2. It had to be on Windows Advanced Server...

Good points about the need for log backups of MSDB. Thanks to all of you for pointing them out to me.

It's rare for us to make changes to our jobs,...

I used Veritas Backup Exec with the SQL Server Agent. I was faithfully backing up my databases every day. Unfortunately, we do not have a test system and I was...

It's interesting to see how everyone viewed this question. I looked at it a different way.

I am the DBA, what if I 'lock out' access to sysprocesses? (Direct access) Is...

Forgot to add....I'm not sure myself what the purpose of the joins are. The only columns you are actually retrieving are from the address column, so you shouldn't need any...

d is a table alias for a derived table...

Look at it in pseudocode:

Join the address table (a) with the values returned by retrieving (selecting) aid and the maximum newid value...

Aziz,

Look again, one of the alias' has an underscore and the other doesn't. (UniqueID and Unique_ID).

Everyone else,

If nothing else, this question has pointed out how important proof-reading is and how...

Biffa,

You assume kwitzell has set an expire time frame. But he/she may not have done so. That's the purpose of my questions.

There is an issue with expire by settings. It...

Please don't cross (double) post. You have this posted elsewhere on this site and have received responses there.

-SQLBill

Ed,

Why switch it to Full? The only purpose of Full Recovery Mode is to be able to do Transaction Log Backups. Microsoft doesn't feel that this is necessary for the...

DM,

I just created dump devices (sp_addumpdevice) and then created a job to run the backup command.

EXEC SP_ADDUMPDEVICE 'disk', 'masterfull', '<path>\masterfull.bak'

BACKUP DATABASE Master TO MasterFull

Refer to the BOL for more...

Henk,

That won't work as the original poster pointed out. @@VERSION will return 760 regardless of whether you have SP3 or SP3a.

From what I have seen on Microsoft's website, they consider...