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.
| 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. |
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System ViewsOther Resources
Integration Services TablesBackup and Restore Tables
Log Shipping Tables
