Returns the rows in the specified conflict table. This stored procedure is run on the computer where the conflict table is stored.
sp_helpmergeconflictrows [ [ @publication = ] 'publication' ] , [ @conflict_table = ] 'conflict_table' [ , [ @publisher = ] 'publisher' ] [ , [ @publisher_db = ] 'publsher_db' ] [ , [ @logical_record_conflicts = ] logical_record_conflicts ]
sp_helpmergeconflictrows returns a result set consisting of the base table structure and these additional columns.
Origin of the conflict.
Code indicating the type of conflict:
1 = Update Conflict: The conflict is detected at the row level.
2 = Column Update Conflict: The conflict detected at the column level.
3 = Update Delete Wins Conflict: The delete wins the conflict.
4 = Update Wins Delete Conflict: The deleted rowguid that loses the conflict is recorded in this table.
5 = Upload Insert Failed: The insert from Subscriber could not be applied at the Publisher.
6 = Download Insert Failed: The insert from Publisher could not be applied at the Subscriber.
7 = Upload Delete Failed: The delete at Subscriber could not be uploaded to the Publisher.
8 = Download Delete Failed: The delete at Publisher could not be downloaded to the Subscriber.
9 = Upload Update Failed: The update at Subscriber could not be applied at the Publisher.
10 = Download Update Failed: The update at Publisher could not be applied to the Subscriber.
12 = Logical Record Update Wins Delete: The deleted logical record that loses the conflict is recorded in this table.
13 = Logical Record Conflict Insert Update: Insert to a logical record conflicts with an update.
14 = Logical Record Delete Wins Update Conflict: The updated logical record that loses the conflict is recorded in this table.
Error code that can be context-sensitive.
Error description that can be context-sensitive.
Time the conflict information was added.