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)
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για