Connecting SQL Servers

• Ravi Kiran Guturu

  Newbie

  Points: 1

  More actions

  May 27, 2005 at 2:54 am

  #102557

  I have 2 servers(Win2k,SQlServer2000) in which one server is in first office and another server is in Second office which is 4 KM away from first office.

  now i want access tables from second server in to first server.

  how do we that?

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  May 27, 2005 at 4:16 am

  #561409

  if you want to import data then you can run the scripts and use DTS

  if you want to access data you can use linked servers check for BOL for more details

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/