Marty:

If I understand you right, you want to create a query that uses tables
on different servers?

That shouldn't be any problem. Just create linked servers and you can
then create a query on one server that "queries" any of its linked
servers.

Steve


-----Original Message-----
From: Marty Galvan
[mailto:mssqldba-ezmlmshield-x20370228.[Email address protected]
Sent: Monday, February 26, 2007 3:46 PM
To: LazyDBA Discussion
Subject: Inner joining different servers

Is it possible to inner join servers on a query? I want to check one
server that is used for web orders to make sure they are getting
imported into our business system. I want to write a query and do a
check to see if they got moved over. Is this possible?

Thanks,

Marty Galvan
DB/EDI Admin
Making Memories
[Email address protected] <mailto:[Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page