i want to know how to reslove conflicts when using Bi-directional transactional replication ,,conflicts like
1-If you insert a record that has a key into a table on one of the servers and another record that has the same key already exists on the other servers that participate in the replication, the replication does not propagate the changes to the other servers.
2-When you update a column in a record that is updated at the same time on another server, the data may be different on the two servers.
3-When you update different columns in a record, simultaneous updates of different columns of a record may sometimes lead to conflicts.
4-When you delete a row that is being deleted at the same time on another server that is participating in the replication, the replication fails because the DELETE statement does not affect any rows on some of the subscribers.
..i need help to know what to do to handle this conflicts and if there is any implementation or any ideas about this issue
View Complete Post