MSmerge_current_partition_mappings

The MSmerge_current_partition_mappings table stores one row for each partition id a given changed row 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 to which the row belongs. The value is –1 if the row change is relevant to all Subscribers.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance