While the linked server is the best option for that, do not forget to give the credentials on which the linkedserver should run which otherwise would give you a security exception....
This is a really good article and it reflects the thoughts going on in the minds of developers who have been working day and night on projects which ultimately are...