How to access data from TWO (2) different SQL Server.

• viplove

  SSChasing Mays

  Points: 653

  More actions

  February 20, 2004 at 2:09 pm

  #82322

  Hello,

   

  I know you can use Linked Server and Open Query to access data between two different SQL server or any type of data source.

   

  My Question is there any other way beside OpenQuery to access data on two SQL Server.

   

  SQL Server 1: SERVER1

  Tables : TAB1, TAB2

  SQL Server 2: SERVER2

  Tables: TABA, TABB

   

  So from SERVER1 can I write a query to access table on SERVER2..TABA

   

   

  Select * from <Server Name>..<database Name>.<Table Name> ????

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  February 20, 2004 at 2:26 pm

  #495004

  Like you said....Linked Server will work. Link the two servers and then in your script use the four-part naming convention as.....

  servername.database.owner.table

   

  -SQLBill

• viplove

  SSChasing Mays

  Points: 653

  More actions

  February 20, 2004 at 2:43 pm

  #495008

  Thanks SQLBill for the fast reply... it worked.... I just have forgot the DBO.