MSmerge_past_partition_mappings (Transact-SQL)


Applies To: SQL Server

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 nameData typeDescription
publication_numbersmallintThe publication number, which is stored in sysmergepublications.
tablenickintThe nickname of the published table.
rowguiduniqueidentifierThe row identifier for the given row.
partition_idintThe ID of the partition the row belongs to. The value is –1 if the row change is relevant to all Subscribers.
generationbigintThe value of the generation in which the partition change occurred.
reasontinyintInternal-use only.

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

Community Additions