SELECT @@SERVERNAME AS 'Server Name' returns 'OldName'
sp_addserver [NewName], local
Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 56
There are still remote logins or linked logins for the server 'OldName'.
Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89
The server 'NewName' already exists.
Msg 15185, Level 16, State 1, Procedure sp_dropremotelogin, Line 68
There is no remote user '(null)' mapped to local user '(null)' from the remote server 'OldName'.
I think the server has been renamed by our network guys while replication is set up.
Can anyone advise me how to drop the remote logins or linked logins and rename the server
Thanks in advance