SQL Server Performance Forum – Threads Archive
Scripting of linked serversTonights 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.