MSpeer_topologyresponse (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

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 name Data type Description
request_id int Identifies a topology status request entry in the MSpeer_topologyrequest table.
peer sysname Name of the server instance that generated the response.
peer_version int Identifies the version number of the Publisher.
peer_db sysname Subscription database at the peer that generated the response.
originator_id int Identifies each node in the topology for the purposes of conflict detection. For more information, see Conflict Detection in Peer-to-Peer Replication.
peer_conflict_retention int Time period, in days, that metadata is stored in conflict tables.
received_date datetime Time at which the topology request was received.
connection_info xml Information about the node that responded to the request.

See Also

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