Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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