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
Leave a Reply