Drop Linked Server IN Sql Server

In previous  blog I told you about to add LinkedServer, if you haven't read that blog then Read Here

In this blog I am going to tell you, how to delete LinkedServer.

Execute this command from master DB.



EXEC sp_dropserver 'LinkedServerName', 'droplogins'

This command removes the remote server servername and all associated remote logins from the local SQL Server.

You can also verify by executing this query.

SELECT * FROM sys.servers