Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2009
    Posts
    3

    Unanswered: how to connect two sql servers

    hello friends

    i am working with microsoft sql server 2000. i want to join tables of two different servers in LAN through query analyzer.

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    See linked servers sp_addlinkedserver
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    be careful about cross server joins. the perf will be really bad if both tables are large.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •