Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_helppeerresponses (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_helppeerresponses (Transact-SQL)

Returns all responses to a specific status request received from a participant in a peer-to-peer replication topology, where the request was initiated by executing sp_requestpeerresponse (Transact-SQL) at any published database in the topology. This stored procedure is executed on the publication database at a Publisher participating in a peer-to-peer replication topology. For more information, see Peer-to-Peer Transactional Replication.

Topic link icon Transact-SQL Syntax Conventions

sp_helppeerresponses [ @request_id = ] request_id

[ @request_id= ] request_id

Is the ID of a specific status request. request_id is int, with no default.

0 (success) or 1 (failure)

Column name Data type Description



ID of the status request.



The name of the peer that generated the response.



The database name at the peer that generated the response.



Date and time that the peer response was sent.

sp_helppeerresponses is used in peer-to-peer transactional replication.

sp_helppeerresponses procedure is used when restoring a database published in a peer-to-peer topology.

Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_helppeerresponses.

Community Additions

© 2015 Microsoft