Export (0) Print
Expand All
Expand Minimize

MScached_peer_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 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.

LSN values are only used immediately after insertion, and they have no lasting meaning in the system.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft