Muokkaa

Jaa


MSpeer_conflictdetectionconfigresponse (Transact-SQL)

Applies to: SQL Server

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:

Started

Peer version collected

Status collected
modified_date datetime Date and time that a phase was completed.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)