Tuesday, October 21, 2014

0 SSMS: Multiple server query

We can configure SSMS to run the query against multiple server simultaneously.

In SSMS, View –> Registered Servers

image

Create new Local Server groups folder called: AlwaysOnDemo and –> New Server Registration

image

Fill in the server connection info and save

image

Then we can run the query for all the servers in the group.

There would be additional column ‘Server Name’ in front of result sets .

image

whether include the server name in the result set can be configured through options

image

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates