SQL Query to Delete a Linked Server Posted by John Colton — April 20, 2012 0 The following stored procedure will remove the linked server instance SQLSERVERINSTANCE along with all associated remote logins: USE [master] GO EXEC master.dbo.sp_dropserver @server=N'SQLNVT08NP2010', @droplogins='droplogins' GO