• vsamantha35 (8/31/2015)


    Thank you. Again, just checking if there is a script which can script out all the Linked servers for a SQL instance at 1 go?

    Yes that process can be scripted out. Is it a script that someone has published for anyone's use, no.

    It would be fairly easy to do with PowerShell and SMO. You would simply connect to your instance and look for the SMO object that contains the Linked Server objects. There should be a method in that object of Script() that you just that output to a file.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton