Drop Linked Server IN Sql Server

Sometimes we get an error while adding linked server:
“The server ‘LinkServerName’ already exists”
The solution is to drop remote server name (with all associated remote logins) using a statement

EXEC sp_dropserver 'LinkServerName', 'droplogins'

After this, we shouldn’t see server name on the list

SELECT * FROM sys.servers

You may also like...

Leave a Reply

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