Post reply

transfer linkedserver

  • March 1, 2011 at 7:08 am

    #144890

    how to transfer all linkedserver from sql 2000 to sql2005?

  • March 1, 2011 at 7:56 am

    #1292941

    ISnt htere any option of scripting out all linked servers?

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • March 1, 2011 at 8:59 am

    #1293013

    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

    #1293016

    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