Posted by Crazy Cat on 12/20/05 17:21

Hi All,

I came up with a workaround -- if you right click on the link server
then select 'Script Linked Server As/ CREATE to/ New Query Window'
Management Studio will generate the code for creating the linked server
in a Query Window. You can then edit the code to change the desired
properties, delete the existing Linked Server, then execute the code to
recreate the linked server. If you then click the refresh selection for
the linked server folder's popup menu you will then see your newly
edited linked server. I found that this pretty much served the same
need as some of the features I'm surprised are missing from Management
Studio, such as an option to copy and paste a linked server or edit the
general properties. Nonetheless, I found that doing it this way is just
as popular, though not as obvious.

Thanks all

[Back to original message]