MScached_peer_lsns (Transact-SQL)

The MScached_peer_lsns table is used to track the LSN values in the transaction log that are used to determine which commands to return to a given Subscriber in peer-to-peer replication. This table is stored in the distribution database.

Definition

Column name

Data type

Description

agent_id

int

The ID of the Distribution Agent.

originator

sysname

The name of the originating Publisher.

originator_db

sysname

The name of the originating publication database.

originator_publication_id

int

Identifies the originating publication.

originator_db_version

int

Identifies the version number of the originating database.

originator_lsn

varbinary(16)

The LSN of the originating transaction.

Remarks

LSN values are only used immediately after insertion, and they have no lasting meaning in the system.