Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

MSpeer_conflictdetectionconfigresponse (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft