How can I run or execute multiple scripts against multiple servers at the same time?
It is possible to execute multiple scripts in the current Editor window against multiple servers or multiple instances on a server.
Example statements:
select @@servername;
select @@SERVICENAME;
select @@CONNECTIONS;
To enable Group execute:
To execute scripts against multiple servers/instances:
1. Select the Group Execute tab on the left side of the Editor window.
2. Select the Enable Group Execute checkbox.
3. Select the connections you want to execute the script against in the Connection tree.
4. Press F5 to execute the SQL
5. Select each connection in the Group Execute tab and each Set to display results for that execution.
NOTE: If you accidentally close the Group Execute tab, you can display it again by right-clicking the editor and selecting Show Group Execute.