mspeer-lsns-transact-sql.md

title	MSpeer_lsns (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	replication
ms.tgt_pltfrm
ms.topic	language-reference
applies_to	SQL Server
f1_keywords	MSpeer_lsns MSpeer_lsns_TSQL
dev_langs	TSQL
helpviewer_keywords	MSpeer_lsns system table
ms.assetid	0ba33907-601b-4c3d-8099-2663f680a161
caps.latest.revision	33
author	BYHAM
ms.author	rickbyh
manager	jhubbard

MSpeer_lsns (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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)