Scripting of linked servers | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Scripting of linked servers

Tonights entertainment is for me to move to two brand new SQL servers. What often happens is it all goes smoothly and then I have to spend an extra hour messing about with the linked server configuration. Is there any way to script these out so they can be readded on the new server? Thanks
I don’t see any such facility to script the process of linked server scripting, rather I would suggest to use SQL Profiler while defining the linked server setup and connections and store them in a .SQL file.
(as I performed at my end) HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>