Linked and remote servers

Last Post 13 Aug 2004 05:09 AM by bigelectricmac. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
bigelectricmac
New Member
New Member

--
12 Aug 2004 01:22 PM
How to migrate linked and remote servers from SQL server 7 to 2000 to another box?
Is there a script to do it ?
bigelectricmac
New Member
New Member

--
13 Aug 2004 05:09 AM
When I manually create Linked server in EM, it asks me for login to linked server, and if I do not have any logins with password there, I cannot create Linked server.
What I try to do is to script linked servers along with logins from source and then re-create them in destination using sp_... system procedures.


Acceptable Use Policy
---