MSpeer_lsns (Transact-SQL)
The Mspeer_lsns table is used to map each transaction to a subscription in a peer-to-peer replication topology. This table is stored in every publication database in a peer-to-peer replication topology and in the subscription database of all Subscribers to a peer-to-peer publication. For more information on this type of transactional replication topology, see Peer-to-Peer Transactional Replication. This table is stored in the publication database.
Definition
| Column name | Data type | Description |
|---|---|---|
id |
int |
Identifies a peer-to-peer LSN. |
last_updated |
datetime |
The datetime at which the last row update was made. |
originator |
sysname |
The name of the Publisher that originated the transaction. |
originator_db |
sysname |
The name of the database in which the transaction originated. |
originator_publication |
sysname |
The name of the publication in which the transaction originated. |
originator_publication_id |
int |
The identifier for the publication in which the transaction originated. |
originator_db_version |
int |
Identifies the version number of the originating database. |
originator_lsn |
int |
Identifies the LSN in the originating publication. |
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