Unreplicated Transactions RRS feed

  • Question

  • This is a two part question.  I'm using transactional replication with a push subsubscription on SQL Server 2008 SP1.

    1. sp_replmonitorsubscriptionpendingcmds returns a large number of peding cmds but MSdistribution_status returns 0 Undeliverd commands.  Judging by the table in the subscriber i believe all the commands have been replicated.  What is the difference between MSDistribution_status and sp_replmonitorsubscriptionpendingcmds?

    2. How do i get a list of commands that haven't been distributed to the subscriber?
    Friday, September 18, 2009 9:03 PM


  • you can use sp_browsereplcmds to see the list of commands, you'll have to query one of the system tables on the subscribed database, it has the the last sequence number that was replicated, you can use this to filter the resultset of sp_browsereplcmds.

    • Marked as answer by Jerry Lew Tuesday, September 22, 2009 1:52 PM
    Monday, September 21, 2009 11:31 PM