How to Run a SQL Query Across Multiple Databases with One Query
Join the DZone community and get the full member experience.
Join For FreeIn 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.
Published at DZone with permission of Merrick Chaffer, DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
Trending
-
Auto-Scaling Kinesis Data Streams Applications on Kubernetes
-
[DZone Survey] Share Your Expertise for Our Database Research, 2023 Edition
-
What Is TTS and How Is It Implemented in Apps?
-
A Data-Driven Approach to Application Modernization
Comments