Question Locked

Querying a large number of Identical SQL Databases on one server

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to query in excess of 100 SQL Databases. All the databases have the same structure and all are on the same server. I know I could write a query per database and union the result of each query but this in not practical. How can I get SQL to loop through one set and query each database.

1 reply

This discussion is closed to new replies.