How to query multiple DBs with teh same name on separate servers? - TechRepublic
Question
August 16, 2011 at 07:19 AM
monzonc

How to query multiple DBs with teh same name on separate servers?

by monzonc . Updated 14 years, 10 months ago

I have multiple servers where I have this app – the app creates the DBs and tables. The DB and tables are call the same on all of the servers.. How can I query the DBs and tables on all of the server with a single query ? The server themselves have unique names.

For example I want to search for a trading partner with the ID of 1234567 on all servers under the same table name..

Thanks,
Carlos

This discussion is locked

All Comments