There are ***still remote logins or linked logins for the server ‘servername’***.

–You can run this query to get a list of remote logins that exist on the server.
— Query to check remote login
select
login.remote_name as RemoteLoginName,
svr.srvname
from sys.remote_logins login join sys.sysservers svr on login.server_id = svr.srvid

sp_dropremotelogin old_server_name
GO

Leave a Reply

Your email address will not be published. Required fields are marked *