March 1, 2011 at 7:08 am
how to transfer all linkedserver from sql 2000 to sql2005?
March 1, 2011 at 7:56 am
ISnt htere any option of scripting out all linked servers?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
March 1, 2011 at 8:59 am
SKYBVI is correct, the easiest way to address linked servers after an upgrade is to use the SSMS and script the linked servers. Be aware, unless you copied the users logins/passwords, these will need to be reentered.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
March 1, 2011 at 9:09 am
Yes, scripting the Linked Servers through SSMS is an easy option. But the password mentioned in the Linked Servers will not be scripted out as I mentioned here[/url]. The password needs to be entered in the script while executing them.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply