There are few records in table which is part of replication having different values for MSRepl_Tran_Version column in publisher and subscriber due to which if there are any updates done to those records in either server it is not getting replicated. For other records where values for MSRepl_Tran_Version is same, replicaiton is working fine.
To solve this problem for one of the records, I manually updated values of MSRepl_Tran_Version to sync both publisher and subscriber and things started working fine.
My problem here is how to identify
1) Mismatch for values in MSRepl_Tran_Version column for each record at publisher and subscriber ?
2) How to figure out which is the latest value that I need to update ?
any thoughts on this will be of great help to me.
Thanks in advance.