| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSpeer_topologyresponse (Transact-SQL) |
MSpeer_topologyresponse (Transact-SQL) |
VanMSFT |
vanto |
03/03/2017 |
sql |
replication |
reference |
|
|
|
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE sql-asdb-asdbmi-asa-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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)