Thursday, 19 July 2018

Renaming a Linked Server

Simple but very helpful as scripting out a linked server won't include the password information.

EXEC master.dbo.sp_serveroption @server=N'OLDNAME', @optname=N'name', @optvalue=N'NEWNAME'

No comments: