ReplTip — Showing pending changes for Merge Replication using sp_showpendingchanges

Share this Post

ReplTip — Showing pending change for Merge Replication
by Sateesh Yele, SQL Server Escalation Services 

We often get merge replication cases where the merge agent is running for long durations and customer would like to know the pending changes at both publisher and the subscriber that the merge agent has to replicate. We do have a system stored procedure sp_showpendingchanges that will provide an approximation of the pending changes that need to be replicated
at that database. This proc will list inserts/updates/deletes per article and can also filter by the subscriber server/database name.

http://msdn.microsoft.com/en-us/library/ms186795.aspx 

However, the proc does not work well when the subscriber database name is same as the publisher database name. Please refer to the below blog for more details. This proc should be used as an approximation to get an idea of number of pending changes and not for exact row count of changes.

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/06/01/sp-showpendingchanges-won-t-show-output-if-subscriber-database-name-is-same-as-publisher-database-name.aspx 


Share this Post

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.