Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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

share|improve this answer

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

share|improve this answer

The ability to edit them left around SQL 2000 or SQL 2005, now they have to be dropped and re-created.

share|improve this answer

Check out sp_setnetname. You can use it to change the data_source of the linked server (destination), e.g.:

DECLARE @name sysname = 'SRVRNAME';
DECLARE @datasource sysname = '';

EXECute sp_setnetname @server = @name, @netname = @datasource;
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.