When I first started at one job, the "dba" role had been given to the chief software architect. He only had one test-duction area. If an object was in ALL...

From the title of the topic, I thought you were going to be talking about trying to revive a 4.x db up to 2000...

I'm not trying to connect. I'm just trying to identify the servers and their specific install properties.

I will look at the software, though. Thanks.

Thanks! We're gonna use xp_regenumvalues to store this information for all prod servers in our DR database.

I had coded (initially in my nightly jobs check routine) to go against MSDB and check for status and average time a job usually takes, but found 2 problems:

1)...

We do a similar thing - check several different servers for failed jobs nightly. We have one job on a master server that queries MSDB on the other servers (yes,...