MSpeer_conflictdetectionconfigresponse (Transact-SQL)
Used in peer-to-peer replication to store each node's response to a topology wide configuration request. This table is stored in the publication database.
Column name |
Data type |
Description |
|---|---|---|
request_id |
int |
Identifies a conflict configuration request entry in the MSpeer_conflictdetectionconfigrequest table. |
peer_node |
sysname |
Name of the server instance that generated the response. |
peer_db |
sysname |
Subscription database at the peer that generated the response. |
peer_version |
sysname |
Identifies the version number of the Publisher. |
peer_db_version |
sysname |
Identifies the version number of the peer database. |
is_peer |
bit |
Indicates whether a node is a read-only Subscriber. A value of 0 indicated a read-only Subscriber. |
conflict_detection_enabled |
bit |
Indicates whether conflict detection is enabled for the topology. |
originator_id |
varbinary(16) |
Identifies each node in the topology for the purposes of conflict detection. For more information, see Conflict Detection in Peer-to-Peer Replication. |
peer_conflict_retention |
int |
Time period, in days, that metadata is stored in conflict tables. |
peer_subscriptions |
XML |
Information about the node that responded to the request. |
progress_phase |
nvarchar(32) |
Identifies the current phase of processing, by using one of the following values:
|
modified_date |
datetime |
Date and time that a phase was completed. |