sp_gettopologyinfo (Transact-SQL)
Applies to:
SQL Server
Returns information about a peer-to-peer transactional replication topology. Execute sp_requestpeertopologyinfo to collect information before you execute this procedure.
Transact-SQL syntax conventions
Syntax
sp_gettopologyinfo [ @request_id = ] request_id
Arguments
[ @request_id= ] request_id
Is the ID of a topology status request. request_id is int, with a default of NULL. To obtain an ID, use the @request_id output parameter from sp_requestpeertopologyinfo or query the MSpeer_topologyrequest system table.
Result Sets
sp_gettopologyinfo returns a result set that has a single XML column. The data in the XML column is the same as the data in the MSpeer_topologyresponse system table.
Return Code Values
0 (success) or 1 (failure)
Remarks
sp_gettopologyinfo is used in peer-to-peer transactional replication. Execute sp_requestpeertopologyinfo before you execute 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 ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για