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.