title
MSpeer_conflictdetectionconfigresponse (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
03/06/2017
ms.prod
sql-server-2016
ms.reviewer
ms.suite
ms.technology
ms.tgt_pltfrm
ms.topic
language-reference
applies_to
f1_keywords
MSpeer_conflictdetectionconfigresponse
MSpeer_conflictdetectionconfigresponse_TSQL
dev_langs
helpviewer_keywords
MSpeer_conflictdetectionconfigureresponse
ms.assetid
2685fb66-731d-40f7-af4b-596b9222c5d4
caps.latest.revision
11
author
BYHAM
ms.author
rickbyh
manager
jhubbard
MSpeer_conflictdetectionconfigresponse (Transact-SQL) [!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md ]
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.
Replication Tables (Transact-SQL) Replication Views (Transact-SQL)