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.
    SQL2, Mar 21, 2008
    #2

  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
    dineshasanka, Mar 21, 2008
    #3

  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.
    SQL2, Mar 21, 2008
    #4

Share This Page