Multiple SQL Server Query results in single Result set

Often I have to run same query against multiple Servers for analysis and club all results for presentation. I come across simple option which allows to do it all in one go…

• View Registered Servers (Ctrl+Alt+G)
• Create new Server Group
• Register New Servers
SQL_Multiple_Servers_Single_Resultset_1

• Add new Serves, you may change the Registered server name with user friendly name.
SQL_Multiple_Servers_Single_Resultset_2

• You may add multiple Servers to the same group and Initiate new query at Server level
SQL_Multiple_Servers_Single_Resultset_3

• You will see the number of Servers connected and execute the Query against all servers in one go
SQL_Multiple_Servers_Single_Resultset_4

Query results will be appended with one additional column, Server Name.

Advertisements
This entry was posted in Productivity, SQL and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s