Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    Ottawa
    Posts
    105

    Unanswered: sp_addlinkserver

    Hi,

    How do I list linked servers in a db, and if necessary, how do I drop them?

    thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You can both see and delete the linked servers using the GUI in SQL Enterprise Mangler.

    I'm a bit of a purist, so I'd use Query Analyzer to list them using:
    Code:
    SELECT srvname
       FROM master.dbo.sysservers
    If I needed to drop them, I'd use sp_dropserver.

    -PatP

  3. #3
    Join Date
    Jun 2003
    Location
    Ottawa
    Posts
    105
    yup. that's it. thanks

Posting Permissions

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