All:

I've had this issue before. It has occured with databases that I migrate from SQL Server 2000 to SQL Server 2005.

To resolve the issue, you need to find and fix...

I'm not sure if this question was ever resolved.

I came up with something you can use; at least as a start. It clobbers the server instance while it runs, but...

Ha! Wow, I just realize that your post was from 2005. Goodess, I really need some coffee.

No, I'm sad to say I've been doing a lot of work with 2000;...

Philip,

I believe I understand why you're having this problem. I'll take a stab at explaining.

When you create your maintenance plan, SQL server creates a job to execute that plan. This...