How to access a table on another database that located on a different server

• dlee-744489

  Grasshopper

  Points: 22

  More actions

  February 11, 2009 at 8:53 am

  #94974

  Hello;

  I'm a SQL Server newbie. I'm trying to write a stored procedure for a Crystal Report extracting records from two different databases each located on a different server. I found that I can use OPENROWSET.

  Can someone show me how to use OPENROWSET?

  Thanks,

  David Lee

• Hadrian

  Hall of Fame

  Points: 3742

  More actions

  February 11, 2009 at 8:58 am

  #942235

  check Books Online

• Hadrian

  Hall of Fame

  Points: 3742

  More actions

  February 11, 2009 at 9:04 am

  #942247

  or use linked server also in BOL

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  February 11, 2009 at 9:11 am

  #942253

  Personally, I don't prefer using OPENROWSET, because it has some securities issues. I recommend you to use Linked Servers, as they are really easy to use. You just need to create a linked server using procedure sp_addlinkedserver & then create a remote server login mapping using the procedure sp_addlinkedsrvlogin. Books Online has an example on it....

  --Ramesh
  

  ---

• dlee-744489

  Grasshopper

  Points: 22

  More actions

  February 11, 2009 at 10:01 am

  #942313

  Thank you.