Question

Locked

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.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Networks Forum
0 total posts (Page 1 of 1)  

Related Forums