MSmerge_past_partition_mappings (Transact-SQL)

The MSmerge_past_partition_mappings table stores one row for each partition id a given changed row used to belong to, but no longer belongs to. This table is stored in the publication database.

Column name Data type Description

publication_number

smallint

The publication number, which is stored in sysmergepublications.

tablenick

int

The nickname of the published table.

rowguid

uniqueidentifier

The row identifier for the given row.

partition_id

int

The ID of the partition the row belongs to. The value is –1 if the row change is relevant to all Subscribers.

generation

bigint

The value of the generation in which the partition change occurred.

reason

tinyint

Internal-use only.

See Also

Reference

Replication Views (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)

Other Resources

How Merge Replication Works

Help and Information

Getting SQL Server 2005 Assistance