I do see that it does create the temp tables in each step if they don't exist. I don't see where it would be storing permanent values, at least I can't find any. But the instructions do say to create them, step 8.

I'm still running this manually from BIDS, I haven't deployed it to SSMS yet. Maybe that is the problem? The MultiServer connection is setup to point to the server housing the SQL_Overview database (at least initially) and it expects those temp tables to be there. So when the instance was restarted, they were dropped, then I couldn't run it manually any longer without recreating them. I believe that's the problem.

So I guess my real question is (if my prior assumption is correct), once I deploy this to SSMS and schedule it, will it behave the same way if the instance is restarted or will it not care at that point since all the create statements will be executed?

I appreciate your help!