mspeer-response-transact-sql.md

title	MSpeer_response (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	replication
ms.tgt_pltfrm
ms.topic	language-reference
applies_to	SQL Server
f1_keywords	MSpeer_response MSpeer_response_TSQL
dev_langs	TSQL
helpviewer_keywords	MSpeer_response system table
ms.assetid	510e24cf-0292-47a9-b1d9-71a30fef030f
caps.latest.revision	29
author	BYHAM
ms.author	rickbyh
manager	jhubbard

MSpeer_response (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

The MSpeer_response table is used in Peer-to-Peer replication to store each node's response to a publication status request. This table is stored in the publication database.

Definition

Column name	Data type	Description
request_id	int	Identifies a status request entry in the MSpeer_request table.
peer	sysname	The peer that generated the response.
peer_db	sysname	The subscription database at the peer that generated the response.
received_date	datetime	The date and time that the peer request was received.

See Also

Replication Tables (Transact-SQL)