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.