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

sp_deletepeerrequesthistory (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).

Deletes history related to a publication status request, which includes the request history (MSpeer_request (Transact-SQL)) as well as the response history (MSpeer_response (Transact-SQL)).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_deletepeerrequesthistory [ @publication = ] 'publication'
    [ , [ @request_id = ] request_id ]
    [ , [ @cutoff_date = ] cutoff_date ]

[ @publication= ] 'publication'

Name of the publication for which the status request was made. publication is sysname, with no default.

[ @request_id= ] request_id

Specifies an individual status request so that all responses to this request will be deleted. request_id is int, with a default value of NULL.

[ @cutoff_date= ] cutoff_date

Specifies a cutoff date, before which all earlier response records are deleted. cutoff_date is datetime, with a default value of NULL.

0 (success) or 1 (failure)

sp_deletepeerrequesthistory is used in a Peer-to-Peer transactional replication topology. For more information, see Peer-to-Peer Transactional Replication.

When executing sp_deletepeerrequesthistory, either request_id or cutoff_date must be specified.

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

Community Additions

© 2015 Microsoft