Ed Wagner (4/25/2015)
Eirikur Eiriksson (4/24/2015)
Quick trick, in SSMS press CTRL+ALT+G to view Registered Servers, if they are grouped you can right click on the group, new query and that instance of the query will be executed on all servers in that group.😎
Eirikur, I can't tell you how many times I've told people about the running SQL against multiple servers using the group. They're always so surprised and can't believe it's that easy.
I know Ed, such useful things as standardizing colour coding for groups, having DAC groups, importing and exporting groups as .regsrvr etc. just don't seems to get through to them.
😎
Maybe you should do a little write up on this, that would be useful!;-)