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.
See Also
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables