Force Drop Publishing and Distributing in Publication/Replication
The below command will tell you how to forcefully remove publisher and distributor in the Replication or Publication ---Show or Delete distributors select * from msdb . dbo . MSdistpublishers delete from msdb . dbo . MSdistpublishers --Drop distribution database EXEC sp_dropdistributiondb 'distribution' ---Drop Distribution USE master go EXEC sp_dropdistributor @no_checks = 1 ----Show publication database EXEC sp_helptext 'sp_MSPublishdb'