Multiserver Queries
Another slick option available with SQL Server 2014 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 3.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 2014 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.
