How to make a Query betweenSQL Servers

• Hugo Capquequi

  Grasshopper

  Points: 12

  More actions

  January 8, 2009 at 7:31 am

  #71129

  I have Two SQL Servers in the same Network, Server A and Server B

  how i make a reference from the server A to Server B

  ex. if i want to make a reference between Databases in the same server , i do this.

  Select * from database..table

  but how i do betwenn Servers ?????

  thanks .

• Garadin

  One Orange Chip

  Points: 29613

  More actions

  January 8, 2009 at 8:36 am

  #923379

  If they are set up as linked servers, you can just add the name of the server to the reference.

  Servername.DatabaseName.Schema.Table .

  If you don't want to use linked servers(not sure why you wouldn't), you can still use OPENQUERY.

  Seth Phelabaum

  ---

  Consistency is only a virtue if you're not a screwup. 😉

  Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

• Hugo Capquequi

  Grasshopper

  Points: 12

  More actions

  January 8, 2009 at 9:54 am

  #923476

  Thanks a lot, it is already done ;);););););)