| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSpeer_conflictdetectionconfigresponse (T-SQL) |
Describes the MSPeer_conflictdetectionconfigureresponse stored procedure used in Peer-to-Peer replication to store each node's response to a topology wide configuration requestion. |
VanMSFT |
vanto |
03/06/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE 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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)