MSpeer_topologyresponse (Transact-SQL)

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.