MSpeer_lsns (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

MSpeer_lsns (Transact-SQL)

 

Applies To: 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 nameData typeDescription
idintIdentifies a peer-to-peer LSN.
last_updateddatetimeThe datetime at which the last row update was made.
originatorsysnameThe name of the Publisher that originated the transaction.
originator_dbsysnameThe name of the database in which the transaction originated.
originator_publicationsysnameThe name of the publication in which the transaction originated.
originator_publication_idintThe identifier for the publication in which the transaction originated.
originator_db_versionintIdentifies the version number of the originating database.
originator_lsnintIdentifies the LSN in the originating publication.
originator_versionintIdentifies the version number of the Publisher.
originator_idsmallintIdentifies 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)

Community Additions

ADD
Show:
© 2016 Microsoft