And the answer is FULL OUTER JOIN! Duh! lol *sigh* I need more caffeine.

Thanks! One of my co-workers suggested the watcher process as well. So we may do that. Thanks! 🙂

Hi Amit!

Here are the answers to your questions.

It's a 32-bit machine.

The total max contiguous block size in KB is 3456.

Also, the errors seem sporadic. We haven't found any patterns...

Thank you! I plan on changing the owner of the maintenance plans and jobs to "sa". The original goal here was to find and update maintenance plans (with corresponding jobs)...

These particular accounts do NOT exist in any groups, whether local or in Active Directory. However, they are AD accounts that have been disabled. Now I am wondering if SQL...

That is a very good point! I just verified on one of the SQL 2005 servers where I'm seeing this issue that the Windows account is NOT part of...

Per a suggestion, I tried to install CU3. Nope. Didn't work. Although I have a different error now:

The installer has encountered an unexpected error. The error code is 2908. Could...

Update: Upon reading the SqlSupport_Cpu64_1.log file, I found this: "APPCOMPAT: no matching ProductCode found in database." So I think something happened to my ProductCode. I'm guessing I need to...

Not sure if I should chime in or not but speaking as Erin's somewhat insane fearless leader 😎 ... I'm sorry to say there really isn't much we can do...