Can SQL Server 2008 Linked Servers be edited? Is there the equivalent of an ALTER statement for Linked Servers?
I have a Linked Server which was made using SQL Server Management Studio 2008.
If the linked server destination changes, I will have to change the properties of it to direct to the right place.
But I cannot - there is no edit option!
Am i missing something, or can Linked Servers not be altered?
Yes, you are right. Linked server name cannot be modified. It needs to be dropped and recreated in case the server name changes.
You can't modify a Linked Server
But if you right click the server in Management Studio and then:
Script Linked Server As > DROP and CREATE to > New Query Editor Window
You can make changes to the script and it's almost the same workflow as using ALTER