Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_helppeerrequests (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns information on all status requests received by participants in a peer-to-peer replication topology, where these requests were 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_helppeerrequests [ @publication = ] 'publication'
    [ , [ @description = ] 'description'

[ @publication= ] 'publication'

Is the name of the publication in a peer-to-peer topology for which status requests were sent. publication is sysname, with no default.

[ @description= ] 'description'

Value that can be used to identify individual status requests, which enables you to filter returned responses based on user defined information supplied when calling sp_requestpeerresponse (Transact-SQL). description is nvarchar(4000), with a default of %. By default, all status requests for the publication are returned. This parameter is used to return only status requests with a description matching the value supplied in description, where character strings are matched using a LIKE (Transact-SQL) clause.

Column name

Data type

Description

id

int

Identifies a request.

publication

sysname

Name of the publication for which the status request was sent.

sent_date

datetime

Date and time that the status request was sent.

description

nvarchar(4000)

User defined information that can be used to identify individual status requests.

0 (success) or 1 (failure)

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

sp_helppeerrequests 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_helppeerrequests.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft