Home Forums SQL Server 2005 SS2K5 Replication SQl 2005 Bidirectional Merge replication - Publisher<->Subscriber Small Data Mismatch RE: SQl 2005 Bidirectional Merge replication - Publisher<->Subscriber Small Data Mismatch

  • FYI i have been monitoring the data on a hour to hour basis and 99.9% of the time all the data is OK but the trend

    seems to be a few records per day fall into the non-convergence category in which case i manually amend the data

    to bring back into convergence but I sure would like a bit of advice on a troubleshooting method for the

    rows of data in question to be able to audit the replication process to identify why the change was not

    pushed out to the subscriber.

    Please note that we can rule out the change happening on the subscriber, this is purely an update on a row of data on

    the Publisher Not Propagating to the Subscriber Regardless of the manual calls to sp_mergedummyupdate to re-push out

    the rows.

    Any advice\comment greatly appreciated.

    Kind Regards,

    Matt