Querying a large number of Identical SQL Databases on one server

By phil.greenaway ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums