Results 1 to 2 of 2

Thread: how to script linked servers

  1. 04-03-2003, 06:51 PM #1
    doyleb
    doyleb is offline Registered User
    Join Date
    Apr 2003
    Posts
    1

    how to script linked servers

    Is there a way to script linked servers and their account for the purpose of copying them to another SQL Server.
    Reply With Quote Reply With Quote
  2. 04-03-2003, 11:24 PM #2
    andi_g69
    andi_g69 is offline Registered User
    Join Date
    Nov 2002
    Location
    DE
    Posts
    246
    Look at table sysservers in master db. That's where SQL stores the linked server information.
    If you alos check the source of sp_addserver you might get theidea of how SQL creates linked server entries.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules