• scogeb (12/7/2012)


    ...I would like to set up some jobs to query all of the instances for certain things and then email me the results...

    I don't know how many instances you have, but I've setup something for myself that collects some daily information about each instance and stores the data in one central database that only I use. The SQL Agent job I created reaches the other servers using SELECT ... FROM OPENROWSET () methodology so I don't need linked servers. You can create the commands from a table with a list of instances, and execute it as dynamic SQL with sp_executesql.