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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Querying a large number of Identical SQL Databases on one server