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

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开发者_如何学C).

Any Directions?

you can use any of the following option :

1) Linked server

2) SSIS

3) OPENROWSET

Maybe this will also help. You can use a feature in SMSS, for registering servers.

Register your servers, and group them. Then just right-click on that group and issue a New Query. The query will be executed against all servers in the group.