Updated: January 15, 2016
THIS TOPIC APPLIES TO:SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
The conflict_<schema>_<table> table contains information about conflicting rows in peer-to-peer replication. A conflict table exists for each replicated table in a publication, where the name of the conflict table is appended with the schema and article name. These article-specific conflict tables exist in each publication database.
For peer-to-peer replication, by default, the Distribution Agent fails when it detects a conflict. A conflict error is logged into the error log, but no conflict data is logged into the conflict table; therefore it is not available for viewing. If the Distribution Agent is allowed to continue, a conflict is logged locally on each node where it was detected. For more information, see "Handling Conflicts" in Conflict Detection in Peer-to-Peer Replication.
ID of the node at which the conflicting change originated. For a list of IDs, execute sp_help_peerconflictdetection.
Node at which the conflicting change originated.
Log sequence number (LSN) of the conflicting change when it was applied at the __$origin_datasource.
Type of conflict, which can be one of the following values:
Indicates whether the row in this table was the winner of the conflict, which means it was applied to the local node.
Version of the database at which the conflicting change originated.
Resolution code for the conflict. Can be one of the following values:
For more information, see __$reason_text.
Resolution for the conflict. Can be one of the following values:
varbinary(n). Size varies depending upon content.
Bitmap that indicates which columns were updated in the case of an update-update conflict.
Date and time that the conflicting row was inserted into this table.
Row version that is associated with the row that caused the conflict.
For a local row, this value is equal to the __$row_id of the incoming row that conflicted with the local row. This value is NULL for an incoming row.
<base table column names>
<base table column types>
The conflict table contains one column for each column in the base table.