use distribution--------------------------------------------------------------------------------select top 100 e.*, * from MSrepl_commands c inner join MSrepl_errors e on c.xact_seqno =e.xact_seqno order by e.id desc--------------------------------------------------------------------------------exec sp_replmonitorhelpsubscription @publisher=NULL, @publication_type=0 --------------------------------------------------------------------------------exec sp_helpdistpublisher --------------------------------------------------------------------------------exec distribution..sp_replmonitorsubscriptionpendingcmds @publisher=pubservername, @subscriber=subservername, @publisher_db='pubdbname', @subscriber_db='subdbname', @publication='pubname', @subscription_type=0 --------------------------------------------------------------------------------exec sp_replqueuemonitor @publisher = pubservername, @publisherdb = 'pubdbname', @publication = 'pubname', @tranid = NULL, @queuetype = 0 --------------------------------------------------------------------------------exec sp_replshowcmds

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'