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

MScached_peer_lsns (Transact-SQL)

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.

Community Additions

ADD
Show:
© 2015 Microsoft