View Single Post
  #1 (permalink)  
Old February 28th, 2006, 08:40 PM
nikotromus nikotromus is offline
Authorized User
 
Join Date: Aug 2004
Location: rogers, ar, USA.
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default Query Between Servers

Hey Guys,

In SQL Server, I am trying to figure out how to write a query between two different tables on two different databases, with the databases located on two different servers. For instance, I want to join table a in database x located on server 1 with table b located in database y on server 2. Any idea how that query would look in Enterprise Manager, and/or how would that query work in a vb.net application.

Thanks,


nikotromus
__________________
nikotromus
Reply With Quote