Unanswered: MSSQL Replication conflict - to resolve?
We are replicating - using Merge with one Publisher and 5 subscribers.
What is currently happening is when someone updates or inserts the same record at two of the servers at roughly the same time it puts that record into the conflict_dbname_jobname_tablename and deletes it from all the other databases. Once you decide on which record in conflict_dbname_jobname_tablename is correct -
i need to know how to resolve the conflict, in other words how to get that record from the conflict table back into the database and the replication loop. if we re-capture the record on the database it just keeps adding to the conflict table.
If anyone can help us out here it would be greatly appreciated.
Neil de Later,
Business Express - Johannesburg,