sysmergepartitioninfo (Transact-SQL)

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

Provides information on partitions for each article. Contains one row for each merge article defined in the local database. This table is stored in the publication and subscription databases.

Column name Data type Description
artid uniqueidentifier The unique identification number for the given article.
pubid uniqueidentifier The unique identification number for this publication; generated when the publication is added.
partition_view_id int The ID of the partition view over this table. The view shows a mapping of each row in the article to the different partition id's it belongs to.
repl_view_id int To be added.
partition_deleted_view_rule nvarchar(4000) The SQL statement used inside a merge replication trigger to retrieve the partition ID for each deleted or updated row based on its old column values
partition_inserted_view_rule nvarchar(4000) The SQL statement used inside a merge replication trigger to retrieve the partition ID for each inserted or updated based on its new column values.
membership_eval_proc_name sysname The name of the procedure that evaluates the current partition IDs of rows in MSmerge_contents.
column_list nvarchar(4000) The comma-separated list of columns replicated in an article.
column_list_blob nvarchar(4000) The comma-separated list of columns replicated in an article, including binary large object columns.
expand_proc sysname The name of the procedure that reevaluates partition IDs for all child rows of a newly inserted parent row, and for parent rows that have undergone a partition change or have been deleted.
logical_record_parent_nickname int The nickname of the top-level parent of a given article in a logical record.
logical_record_view int A view that outputs the top-level parent article rowguid corresponding to each child rowguid.
logical_record_deleted_view_rule nvarchar(4000) Similar to logical_record_view, except the it shows child rows in the "deleted" table in update and delete triggers.
logical_record_level_conflict_detection bit Indicates whether conflicts should be detected at the logical record level or at the row or column level.

0 = Row- or column-level conflict detection is used.

1 = Logical record conflict detection is used, where a change in a row at the Publisher and change in a separate row the same logical record at the Subscriber is handled as a conflict.

When this value is 1, only logical record level conflict resolution can be used.
logical_record_level_conflict_resolution bit Indicates whether conflicts should be resolved at the logical record level or at the row or column level.

0 = Row- or column-level resolution is used.

1 = In case of a conflict, the entire logical record from the winner overwrites the entire logical record on the losing side.

A value of 1 can be used with both logical record-level detection and with row- or column-level detection.
partition_options tinyint Defines the way in which data in the article is partitioned, which enables performance optimizations when all rows belong in only one partition or in only one subscription. partition_options can be one of the following values.

0 = The filtering for the article either is static or does not yield a unique subset of data for each partition, i.e. an "overlapping" partition.

1 = The partitions are overlapping, and DML updates made at the Subscriber cannot change the partition to which a row belongs.

2 = The filtering for the article yields non-overlapping partitions, but multiple Subscribers can receive the same partition.

3 = The filtering for the article yields non-overlapping partitions that are unique for each subscription.

See Also

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