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).
When executed from a node in a peer-to-peer topology, this procedure requests a response from every other node in the topology. By executing this procedure and reviewing the corresponding responses, you can guarantee that all previous commands have been delivered to the responding nodes. This stored procedure is executed at the requesting node on any database.
sp_requestpeerresponse is used in peer-to-peer transactional replication.
sp_requestpeerresponse is used to ensure that all commands have been received by all other nodes before restoring a database published in a peer-to-peer topology. It is also used when replicating data definition language (DDL) changes made while a node was offline to estimate when these changes arrive at the other nodes.
sp_requestpeerresponse cannot be executed within a user-defined transaction.