MSpeer_topologyresponse (Transact-SQL)


Applies To: SQL Server

Used in peer-to-peer replication to store the response of each node to a topology status request. This table is stored in the publication database.

Column nameData typeDescription
request_idintIdentifies a topology status request entry in the MSpeer_topologyrequest table.
peersysnameName of the server instance that generated the response.
peer_versionintIdentifies the version number of the Publisher.
peer_dbsysnameSubscription database at the peer that generated the response.
originator_idintIdentifies each node in the topology for the purposes of conflict detection. For more information, see Conflict Detection in Peer-to-Peer Replication.
peer_conflict_retentionintTime period, in days, that metadata is stored in conflict tables.
received_datedatetimeTime at which the topology request was received.
connection_infoxmlInformation about the node that responded to the request.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions