| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSpeer_lsns (Transact-SQL) |
MSpeer_lsns (Transact-SQL) |
VanMSFT |
vanto |
03/06/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server]
The Mspeer_lsns table is used to map each transaction to a subscription in a peer-to-peer replication topology. This table is stored in every publication database in a peer-to-peer replication topology and in the subscription database of all Subscribers to a peer-to-peer publication. For more information on this type of transactional replication topology, see Peer-to-Peer Transactional Replication. This table is stored in the publication database.
| Column name | Data type | Description |
|---|---|---|
| id | int | Identifies a peer-to-peer LSN. |
| last_updated | datetime | The datetime at which the last row update was made. |
| originator | sysname | The name of the Publisher that originated the transaction. |
| originator_db | sysname | The name of the database in which the transaction originated. |
| originator_publication | sysname | The name of the publication in which the transaction originated. |
| originator_publication_id | int | The identifier for the publication in which the transaction originated. |
| originator_db_version | int | Identifies the version number of the originating database. |
| originator_lsn | int | Identifies the LSN in the originating publication. |
| originator_version | int | Identifies the version number of the Publisher. |
| originator_id | smallint | Identifies each node in the topology for the purposes of conflict detection. For more information, see Conflict Detection in Peer-to-Peer Replication. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)