Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Diff values of MSRepl_Tran_Version column for records in publisher and subscriber Expand / Collapse
Author
Message
Posted Tuesday, May 25, 2010 12:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 17, 2012 11:29 PM
Points: 138, Visits: 236
Hi All,

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.
Post #927214
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse