We have a lot of SQL Servers, and sometimes we need to run ad hoc queries against multiple servers at once.
Usually I add each server that I want to query under Registered Servers > Local Server Groups in SQL Management Studio. However this can become time consuming.
What I want to achieve is to be able to import a large list of Servers at once, either via a script or xml builder that can achieve this for me.
Has anyone already done this, or can they point me in the right direction?
View Complete Post