SQL 2005 Query across multiple servers
Posted on 2009-05-16
I have a question about building a query in SQL 2005 that I hope someone can answer for me. Basically we have a few SQL Servers in our oganisation and we need to create a report to show some difference between 2 of them whilst we undergo a few integration changes.
So basically the first question is:
Can you query from different tables contained within different SQL instances? If so, how is ths done?
One I know if this is the correct way then I can move onto creating my queries and if I need to export the data from one to the other then I need to do this but it would be a lot easier if I could query from multiple instances.
Thanx in advance for any advice