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'
Comments