Can SQL Server 2008 Linked Servers be edited? Is there the equivalent of an ALTER statement for Linked Servers

linked-serversql-server-2008

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?

Best Answer

Yes, you are right. Linked server name cannot be modified. It needs to be dropped and recreated in case the server name changes.

Related Topic