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 =1
exec sp_removedbreplication 'systest_1'
Mark Cooper 
Leave a Reply