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)
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