Click to Rate and Give Feedback
TechNet
TechNet Library
SQL Server
SQL Server 2005
 MSmerge_past_partition_mappings (Tr...

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
SQL Server 2005 Books Online (November 2008)
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.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker