Create a view in one server from a query to a different server

Question

I'm using SQL Server 2005. I have a query to a server that gives a huge result set and I'd like to save that in a view on my local server. Is there a way to either create a view from the server to my local server database directly, or export the result set locally and import it into my local server's database. Thanks! JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

You could use OPENDATASOURCE or a linked server query from your local server to the remote server. That would allow you to create an object such as a temporary table locally and populate it with data from the remote server. There is plenty of information on implementing this in Microsoft's online documentation.