question

Sharma avatar image
Sharma asked

Merge replication synchronisation issue

Basically two or more users are trying to update the same record in the same database (through merge replication)…and the changes are not being saved after a synchronization. They are, however able to update different records and the changes are saved after synchronization.
merge-replicationsynchronisation
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Cyborg avatar image
Cyborg answered
This is because of merge replication conflicts, conflicts happen when a same row\column is updated from different sites. If your conflict resolution is not "interactive" SQL Server will handle the conflicts automatically and the winner row is updated across all servers and the loosing rows are written into conflict table conflict___. You can view these information in conflict viewer also. [KB article][1] about conflict. [1]: http://support.microsoft.com/kb/315514
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.