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? ThanksI 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.
]]>