How to Run a SQL Query Across Multiple Databases with One Query
In SQL Server management studio, using, View, Registered Servers (Ctrl+Alt+G) set up the servers that you want to execute the same query across all servers for, right click the group, select new query. Then when you execute the query, the results will come back with the first column showing you the database instance that that row came from.
Database
sql
Published at DZone with permission of Merrick Chaffer. See the original article here.
Opinions expressed by DZone contributors are their own.