MSmerge_past_partition_mappings (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)