Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sysmergepartitioninfo (Transact-SQL)

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.