Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    35

    Unanswered: Capture Linked Server names with Cursors

    Hi

    Please could anyone tell me how I could obtain a list of created linked servers that aready exists using the SELECT statement.

    I know sp_linkedservers can be used but I need to use the SELECT statemetn to store all the names in a cursor.


    Thanks in advance

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    sys.servers should give you what you need
    George
    Home | Blog

  3. #3
    Join Date
    Jun 2008
    Posts
    35
    thanks.

    this would really help

Posting Permissions

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