I'm having the same problem have you received any responses or resolved this issue?

Jim - Thanks again.

I'll let you know how it turns out.

Frank

Thanks Jim!  So it's ok to do the integrity check, but not as part of the Maintenance Plan - am I reading that right?  So would the process be to...

Now we're getting somewhere.  The Activity that failed was Check Data and Index Linkage - Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single...

It's not very descriptive at all.  "The Job Failed".  It says who it was executed by and that's about it.

We do have backup software that runs for the server, but these backups are occuring at other times so that doesn't seem to be the issue.  I will check profiler...

Both the domain admin and the sa accounts have the proper privaleges and we've tried under both and have experienced failure for both.  If there are people on the server...

Bessebo,

Thanks for the encouragement.  We are on SQL2000 so that would probably be a good place to start as I don't really see us going to 2005 anytime real soon.

I...

I too wanted to read more.  My experience over the last 10 years has been primarily as a developer and in some projects I have had to design the database...