Jorge Serres (4/18/2012)

---

Was testing it and it runs gr8! However, it'd be good if could be extended to run for multiple Databases within the given server or even servers.

So, I'd add two columns to the table. Servername and DatabaseName both of type sysname. The extend the code accordingly.

Sometimes I needed to identify in which Databases and servers does a given sproc or table exists.

So, I wrote about 5 years ago a sproc that would actually comb all sysservers (via linked) and collect all the info for every DB.

Today a faster and more elegant approach would be using SQLPS. (POSH)

This concept is useful when one knows that one has implemented in a given step of a job something handy. It happens that the only thing one can remember is that the job step contained something such as "DTEXEC ....", but certainly among so many servers and jobs within each, is an ocean of info that one would have to deal with.

So, it comes really handy to tap into all jobs and jobsteps on every server and immediately find, what one is looking for.