MScached_peer_lsns (Transact-SQL)
Applies to: SQL Server
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)