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