Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayMSmerge_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 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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)