conflict_<schema>_<table> (Transact-SQL)
Applies to:
SQL Server
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.
Column name | Data type | Description |
---|---|---|
__$originator_id | int | ID of the node at which the conflicting change originated. For a list of IDs, execute sp_help_peerconflictdetection. |
__$origin_datasource | int | Node at which the conflicting change originated. |
__$tranid | nvarchar (40) | Log sequence number (LSN) of the conflicting change when it was applied at the __$origin_datasource. |
__$conflict_type | int | Type of conflict, which can be one of the following values: 1: An update failed because the local row was changed by another update or it was deleted and then reinserted. 2: An update failed because the local row was already deleted. 3: A delete failed because the local row was changed by another update or it was deleted and then reinserted. 4: A delete failed because the local row was already deleted. 5: An insert failed because the local row was already inserted or it was inserted and then updated. |
__$is_winner | bit | Indicates whether the row in this table was the winner of the conflict, which means it was applied to the local node. |
__$pre_version | varbinary (32) | Version of the database at which the conflicting change originated. |
__$reason_code | int | Resolution code for the conflict. Can be one of the following values: 0 1 2 For more information, see __$reason_text. |
__$reason_text | nvarchar (720) | Resolution for the conflict. Can be one of the following values: Resolved (1) Unresolved (2) Unknown (0) |
__$update_bitmap | varbinary( n ). Size varies depending upon content. | Bitmap that indicates which columns were updated in the case of an update-update conflict. |
__$inserted_date | datetime | Date and time that the conflicting row was inserted into this table. |
__$row_id | timestamp | Row version that is associated with the row that caused the conflict. |
__$change_id | binary (8) | 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. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें