Query two different Servers

Posted by Felipe Fiali on Stack Overflow See other posts from Stack Overflow or by Felipe Fiali
Published on 2010-05-18T21:14:54Z Indexed on 2010/05/18 21:40 UTC
Read the original article Hit count: 408

Filed under:
|
|
|
|

I have to query two different servers from a dynamically built query.

It basically gets data from one server, treats it, and inserts it into another server.

The only problem is I have to be sure it works for both situations: If both the source and destination databases are on the same server, and if they're not.

I understand the concept of using Linked Servers in SQL Server, but I cannot think of a way to consider both alternatives, same server and different servers.

A little help?

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about sql