Hi,

I need to transfer all the linked servers present in the
remote sql server to a local sql server. How can i do it?

Regards,

There isn't a scripting option available. We've filed this as a Design
Change Request for the next release.
You'll need to manually add the entries.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.