Linked server, ave made it using sql srvr mngmnt stdio 2008.......

now 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 linked servers can not be altered?

link|improve this question

50% accept rate
feedback

2 Answers

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

link|improve this answer
feedback

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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