Sorry to reply to my own thread, but we figured this out today. SQL Agent in SQL2000 apparently cannot deal with the returns from the SQL statements when NOCOUNT is...

I finally found the information on another MS forum. As I mentioned in the original message, I wasn't worried about user databases, but system ones (master, model, msdb, tempdb). ...

Doh! See, it was easier to mess this up than I thought.

I'd blame it on being sick, but I'm not sure it...

Sorry. I'm using QA 8.00.760 running against SQL2KSP3. I've tried it on several different PC's running that QA, running against several different servers.

By "as expected", you mean you...

Well, it's really two things. One, having to use dynamic SQL seems like it's pretty unintuitive, so I wanted to make sure I wasn't doing something wrong. I...