If you ignore schema updates and changes, development changes, etc... we have three applications over 10 years old, with DB's that have gone through several systems upgrades - SQL 2000...

That works OK when you have one single query you wish to run against one linked server.

However the situation I have is that I have two environments each with several...