sp_requestpeertopologyinfo (Transact-SQL)
Collapse the table of content
Expand the table of content

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

Populates the MSpeer_topologyresponse system table with information about a peer-to-peer transactional replication topology. Execute sp_gettopologyinfo to obtain information from the table in XML format.

Topic link icon Transact-SQL Syntax Conventions

sp_requestpeertopologyinfo [ @publication = ] 'publication'
        [ ,[ @requestid=] request_id OUTPUT

[ @publication= ] 'publication'

Is the name of the publication for which to perform a topology-wide status request. publication is sysname, with no default.

[ @request_id= ] request_id

Is the ID number that is assigned to the topology status request. request_id is int, with a default of NULL. This ID can be used by sp_gettopologyinfo.

0 (success) or 1 (failure)

sp_requestpeertopologyinfo is used in peer-to-peer transactional replication. Execute sp_requestpeertopologyinfo before executing sp_gettopologyinfo. These procedures are used by the Configure Peer-to-Peer Topology Wizard, but they can also be used directly if you require topology information in an XML format. If you prefer tabular results, query the MSpeer_topologyresponse system table.

Requires membership in the sysadmin fixed server role or db_owner fixed database role.

Community Additions

© 2016 Microsoft