Perfect!

Thanks Gus.

That's a lot cleaner and simpler than using the FROM dual clause.

Thank you yewang80 and Gus - you nailed it. The problem was that dual was empty in [msdb] but not in the user databases. Doh! I should have compared more...

I actually expect to have NULL columns dropped, and not appear in the resulting XML.

The problem is that the whole variable @XML is set to NULL when [msdb] is the...

I tried your suggestion before making the post - it behaved the same way. I have since read elsewhere that VB seems to be the last programming language that behaves...

I removed Lumigent Log Explorer from this server, and the problem went away. I will put it back on after a month of stability to see what happens.

I changed the package to DelayValidation and the job now works OK (last 3 days). This doesn't make any sense to me, since the package was failing at the 4th...

I've changed the package to log errors, so I'll see where that leads. I don't know about delay validation. I'll check into it. Thanks.

Yes, DNS is involved, since the app uses the server name, not IP address. The old and new servers have different names and addresses.

Yes, I can see the failed...

You're right - that isn't the case, and it is a head scratcher. The database connection is made through 3rd-party software, which prompts for the user ID and password. It...

Sort of. The old system had 4 databases - Live, Training, Test and Backup. The latter 3 are refreshed periodically from the Live database, so are essentially the same, and...

Julie,

sp_change_users_login 'report' returned no rows (no orphaned users).

My understanding of the sp_help_revlogin process is that it creates logins on the target server with the same SID and password as on...

Brian,

The SS log shows nothing other than these login failures (and normal activity such as scheduled jobs starting and finishing). This is on a new server which is "heftier" than...

I'm not sure what that means. However, I have looked at the system event logs and do see Failure Audit entries in the Application log for the people reporting the...

I've checked the password case - the users are entering the password correctly.

I did have one user for which "Enforce password policy" was checked. I don't know how that...

The default database was master on 2000, and still is on 2005. The application login takes care of connecting to the correct database. It is the application that prompts for...