mspeer-topologyresponse-transact-sql.md

title	MSpeer_topologyresponse (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	MSpeer_topologyresponse MSpeer_topologyresponse_TSQL
dev_langs	TSQL
helpviewer_keywords	MSpeer_topologyresponse
ms.assetid	1bc5c0c6-c432-405c-89fd-e953d173a247
author	stevestein
ms.author	sstein
monikerRange	>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

MSpeer_topologyresponse (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all-md]

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.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)