title
MSpeer_topologyresponse (Transact-SQL)
description
MSpeer_topologyresponse (Transact-SQL)
author
VanMSFT
ms.author
vanto
ms.date
03/03/2017
ms.service
sql
ms.subservice
replication
ms.topic
reference
f1_keywords
MSpeer_topologyresponse
MSpeer_topologyresponse_TSQL
helpviewer_keywords
dev_langs
monikerRange
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current
MSpeer_topologyresponse (Transact-SQL) [!INCLUDE sql-asdb-asdbmi-asa-pdw ]
Used in peer-to-peer replication to store the response of each node to a topology status request. This table is stored in the publication database.
Column name
Data type
Description
request_id
int Identifies a topology status request entry in the MSpeer_topologyrequest table.
peer
sysname Name of the server instance that generated the response.
peer_version
int Identifies the version number of the Publisher.
peer_db
sysname Subscription database at the peer that generated the response.
originator_id
int 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.
received_date
datetime Time at which the topology request was received.
connection_info
xml Information about the node that responded to the request.
Replication Tables (Transact-SQL) Replication Views (Transact-SQL)