when struggling to drop a publication or subscription from the API, try one of these: use [SysTest_1]exec sp_dropsubscription @ignore_distributor =1,@publication = N'all', @subscriber=N'all',@article = N'all'exec sp_droppublication @publication = N'all',@ignore_distributor =1exec sp_removedbreplication 'systest_1'