How to access multiple servers in the same SQL Server query?

Question

One database is SQL Server 2005 and other one is 2008.

I have to write a query which should pull data from both servers (I have to write a query in my local SQL box).

Any Directions?

Answer 1

you can use any of the following option :

1) Linked server

2) SSIS

3) OPENROWSET