Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

3 Answers 3

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
add comment

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
add comment

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
add comment

Your Answer

 
discard

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.