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.