Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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
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 set
sp_gettopologyinfo returns a result set that's 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 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.