Tuesday, October 21, 2014

1 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

1 comments:

  1. Your writing skill is amazing because only some writers can lead the readers with them and show what secrets are hidden in human minds, hats off and cheers. best essay writing service review

    ReplyDelete

 

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