Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Merge replication fake conflicts

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2014-03-10 : 06:36:30
Hi all,

I'm seeing a lot of conflicts in my merge replication.

My conflict resolution setting is that the Publisher always wins in the event of a conflict.

As I understand conflicts occur when a row is being changed on the publisher and subscriber at the same time.

However in my situation I have some rows where a change was made on the subscriber a month after it was made on the publisher, yet SQL Server is viewing this as a conflict and overwriting the row change on the subscriber.

Has anyone ever seen anything like this?

It seems very bizarre and almost like a corruption.
   

- Advertisement -