This will happen if the job is scheduled as a dependency on a previous job, as opposed to having a specific time to run it.

For example, job 1 runs...

You're right that it doesn't take two tables to provide an example, but it still comes down to using ambiguous labels.

As for the explanation, I think Rayven's description was excellent.

This WAS an interesting and fun question. Thank you Ronald C. for submitting it.

But how many of us would ever return the Select results

into an ambiguously specified variable? (Remember the...

According to the MicroSoft article cited above, the order in reattaching is critical. So as David says - attach Model first and then MSDB.

Also, the article says:

Note If you try...

Awsome. Thanks, Steve. Can you also change my vote to "Excellent" for me?

This article is a good read, but would be much more useful if the rest of the code was included.

Domain-level policy settings override local policy settings. Perhaps your complex passwords are set at the domain level.

Lots of info on replication, but not much on heterogeneous replication out there. Try

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replprog/replprogrdi_63ar.asp

 and for SQL Server CE:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replimpl_6pet.asp

Hans is right. According to the rationale given for their supposed correct answer:

Once you rename a server and reboot the machine, you must only run the three...