Export (0) Print
Expand All
Expand Minimize

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:

  • Started

  • Peer version collected

  • Status collected

modified_date

datetime

Date and time that a phase was completed.

Community Additions

ADD
Show:
© 2014 Microsoft