SQL Server Performance

Verify that all Records added at the Publisher is replicated/propagated to Subscriber

Discussion in 'SQL Server 2005 Replication' started by SQL2, Mar 21, 2008.

  1. SQL2 New Member

    In Merge Replication, how do you verify that all Records added at the Publisher is replicated/propagated to the Subscriber and all records added at the Subscriber is replicated/propagated to the Publisher.
    I am using SQL Server 2005.
  2. dineshasanka Moderator

    Select m.name,Count(m.name) as Total, CONVERT(varchar(25),mg.coldate,100) as [Date] FROM MSmerge_contents mc INNER JOIN sysmergearticles m ON mc.tablenick = m.nickname INNER JOIN msmerge_genhistory mg ON mc.generation = mg.generation GROUP BY mg.coldate, m.name ORDER BY mg.coldate desc
    will give you row counts so that you can match
  3. SQL2 New Member

    Thanks Dineshasanka.
    Please can you give a brief explanation of what the script is doing interms of verifying that records were inserted at both publisher and subscriber.
    Thanks.

Share This Page