MSpeer_lsns (Transact-SQL)

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.

Definition

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.