The MSmerge_delete_conflicts table contains information for rows that were deleted because either they conflicted with an update and lost the conflict or the delete was undone to achieve data convergence. This table is stored in the database used for conflict logging, usually the publication database but can be the subscription database if there is decentralized conflict logging.
|Column name||Data type||Description|
|tablenick||int||Nickname of the table.|
|rowguid||uniqueidentifier||Row identifier for the deleted row.|
|origin_datasource||varchar(255)||Subscription for which the delete of the row was undone or the delete lost the conflict.|
|conflict_type||int||Type of conflict:
1 = UpdateConflict: Conflict is detected at the row level.
|reason_code||int||Error code. May be context-sensitive-based on conflict_type.|
|reason_text||nvarchar(720)||Description of the error code.|
|create_time||datetime||The datetime value when the current conflict row was logged.|