Results 1 to 2 of 2

Thread: Linked Servers

  1. #1
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250

    Unanswered: Linked Servers

    Hello,


    Is there any limit to the number of linked servers i can add via EM?. where can i find more info on adding/configuring linked servers in MSSQL2k and the limitations/drawbacks if any?


    Thanks in advance..
    Cheers....

    baburajv

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    one limitation of linked servers I discovered recently is that loopback scenarios are not supported by MS, even though they often work. what I mean by loopback is a LS that points to itself.

    One case I know that is broken in a loopback scenario is this:

    INSERT INTO localtable EXEC LoopbackLinkedServer.dbo.RemoteSproc

    as is detailed here:

    http://forums.microsoft.com/MSDN/Sho...24137&siteid=1

    Linked servers are very useful. why couldn't MS get the obvious use case of loopback to work?

    I should note that the case above is broken on 2005. it may work on 2000, I haven't tried it.
    Last edited by jezemine; 09-29-06 at 04:12.

Posting Permissions

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