join tables of different databases on different server

• Tsql-561486

  SSC Eights!

  Points: 821

  More actions

  December 10, 2007 at 4:05 am

  #181226

  Hi,

  Please let me know how to join a table from one server(S1) with a table on another server(S2).

  Any idea.

• psaunders-573788

  SSC Rookie

  Points: 25

  More actions

  December 10, 2007 at 8:56 am

  #758633

  Try this:

  http://vyaskn.tripod.com/programming_faq.htm#q14

• SQL_ABD

  SSCertifiable

  Points: 5832

  More actions

  December 12, 2007 at 1:02 am

  #759284

  Hi,

  You can also use the OPENROWSET wich is an alternative to accessing tables in a linked server.

  Checkthe following link

  http://msdn2.microsoft.com/en-us/library/aa276850(SQL.80).aspx

  Regards,

  Ahmed