July 18, 2016 at 9:42 pm
Comments posted to this topic are about the item Changing a Linked Server Name
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 19, 2016 at 1:04 am
I'm so happy I didn't have to use linked servers for over 7 years now 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 19, 2016 at 5:16 am
I've used them and must admit I was somewhat excited to see the question. Alas, nothing has changed.
July 19, 2016 at 6:27 am
Though I scored correctly but eager to know if there is any specific logic behind not to have alter statements in place instead of Delete and Create!!
Thanks.
July 19, 2016 at 6:49 am
This was removed by the editor as SPAM
July 26, 2016 at 1:12 pm
This seems to work:
EXEC sys.sp_serveroption @server = N'currentname', @optname = 'name',
@optvalue = N'newname';
It's not documented, so if there are any caveats I'm not aware of them. But it updates the name column of sys.servers just fine, no single-user mode required.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply