Debugging Replication Errors

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

A WordPress.com Website.

Up ↑