Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSpeer_lsns (Transact-SQL)
Collapse the table of content
Expand the table of content

MSpeer_lsns (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

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.

Community Additions

ADD
Show:
© 2015 Microsoft