December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...