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.
