MSpeer_lsns (Transact-SQL)

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.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance