Tuesday, October 21, 2014

8 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

8 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
  2. If you are looking for the deviation calculator then you must have to visit standard deviation this will provide you all and the best services to meet your needs

    ReplyDelete
  3. I am a Wix Expert / Website Enthusiast. I am enjoying working on Wix as it's my passion. I Design Wix Website for various businesses

    ReplyDelete
  4. Corona virus is an infectous disease we can protect us from this dangerous disease by using Face Mask.

    ReplyDelete
  5. Every fashion trend you should know about in 2020. Our experts show you how to wear the latest Men trending Fashion for this season and next.

    ReplyDelete
  6. Wholesaling or distributing is the sale of goods or merchandise to retailers; to industrial, commercial, institutional or other professional business users; or to other wholesale dealer (wholesale businesses) and related subordinated services.

    ReplyDelete
  7. Are you looking for the Security Guard Service for Banks that you can trust? Do you want the best in the industry for a competitive price? Look no further than Rowe Solutions for all your security needs, regardless of the style or size of your request.

    ReplyDelete

 

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