Records in the Conflict tables even though Custom Resolver is working
Posted on 2006-10-24
I have merge replication setup between two SQL2000 (SP3a) DBs.
The Subscriber synchronises with the Publisher every 15mins and has been like this for 2 years.
Updates are allowed on both DBs
I am using the Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver to resolve any conflicts where the same record is updated on both DBs.
The "resolve conflicts interactively" option is not enabled.
The resolver is working fine and the record with the latest date always wins.
However I have recently noticed that in EM I can View Conflicts and choose to "Keep winning change" or "Resolve With This Data" on conflicts that have already been resolved.
My question is, although the resolver is working correctly why are records appearing in the Conflict tables?
Should I be concerned by the records in the conflict table or will they be automatically removed after a certain time?
Thanks in advance,