RenameLinkdedServer

exec sp_dropserver 'OLDNAME' go exec sp_addserver 'NEWNAME' go exec sp_serveroption NEWNAME, 'data access', 'true' go