The image shows this update conflict:
Steps | On Database A | On Database B |
---|---|---|
Initial condition. | X is 1. | X is 1. |
The application on each database updates X simultaneously. | Set X=2. | Set X=100. |
The replication agent on each database sends its update to the other database. | Replicate X to Database B | Replicate X to Database A. |
Each database now has the other's update. | Replication says to set X=100. | Replication says to set X=2. |
End of description.