How to access another database server from the exisitng database

• Abraham-228683

  SSC Rookie

  Points: 40

  More actions

  April 27, 2005 at 5:39 am

  #67312

  Hi

  database server is sqlserver

  I need to access  the content one database server through another. is there any way

• wz700

  SSCertifiable

  Points: 7133

  More actions

  April 27, 2005 at 6:45 am

  #555190

  Use linked server or openquery.

  Check BOL(book on line) for detail syntax and samples.

• Abraham-228683

  SSC Rookie

  Points: 40

  More actions

  April 28, 2005 at 3:18 am

  #555466

  Thnks for the reply>>