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.
|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.|
LSN values are only used immediately after insertion, and they have no lasting meaning in the system.