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. |