How to query multiple DBs with teh same name on separate servers?Locked
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..