MSpeer_lsns (Transact-SQL)
Applies to:
SQL Server
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. |
originator_version | int | Identifies the version number of the Publisher. |
originator_id | smallint | Identifies each node in the topology for the purposes of conflict detection. For more information, see Conflict Detection in Peer-to-Peer Replication. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru