Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    95

    Unanswered: Linked Server and Remote Server Help

    I'm documenting various server configurations such as linked and remote servers. Rather then clicking on each linked and remote server to view their properties I am trying to query sysservers. According to BOL, the column isremote is 1 if server is a remote server, else 0 if server is a linked server. When I query sysservers I see just the opposite. Is BOL wrong or am I missing something? Through Enterprise Manager I see 3 remote servers and 13 linked servers. syssservers shows 3 servers with isremote = 0 and 13 servers with isremote = 1.

    Also, I understand remote servers are provided for backward compatibility. If that is the case, why is the default instance listed under remote server and not linked server. Also, why does replication list repl_distribution under remote server and in some cases the subscriber server is also listed under remote servers.

    Thanks, Dave

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    To answer you last 2 questions, - for backward compatibility...but wait, you already answered it

  3. #3
    Join Date
    Jan 2003
    Posts
    95
    Backward compatibility usually applies to the user so processes don't break as the result of the upgrade. In this case I'm referring to how Microsoft stores server names for the default instance and replication data. You would think they would follow their own advice and use Linked Servers, not Remote Servers.

    Dave

Posting Permissions

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