MScached_peer_lsns (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)