Multiserver Queries

Another slick option available with SQL Server 2012 is the capability to execute a script on multiple servers at once. Multiserver queries allow the contents of a single query editor window to be run against all the servers defined in a given registered server group. After the group is created and servers are registered in the group, you can right-click the group and select the New Query option to create a query window that can be run against all the servers in the group. Click the Execute button, and the query is run against all the servers. Figure 4.32 shows a server group named MyTestGroup containing three servers registered in that group, a sample query to run against these servers, and a single result window that shows ...

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.