sp_requestpeertopologyinfo (Transact-SQL)
Applies to: SQL Server
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.
Transact-SQL syntax conventions
Syntax
sp_requestpeertopologyinfo [ @publication = ] 'publication'
[ ,[ @requestid=] request_id OUTPUT
Arguments
[ @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.
Return Code Values
0 (success) or 1 (failure)
Remarks
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.
Permissions
Requires membership in the sysadmin fixed server role or db_owner fixed database role.
See Also
Peer-to-Peer Transactional Replication
Replication Stored Procedures (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru