Condividi tramite


PartitionOptions Enumeration

Enumerates the ways in which data in an article is partitioned amongst subscriptions when the merge publication uses a parameterized row filter.

Spazio dei nomi: Microsoft.SqlServer.Replication
Assembly : Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Sintassi

'Dichiarazione
Public Enumeration PartitionOptions
public enum PartitionOptions
public enum class PartitionOptions
public enum PartitionOptions
public enum PartitionOptions

Members

Member name Description
NonOverlappingSharedBetweenSubscriptions The filtering for the article yields non-overlapping partitions, but multiple Subscribers can receive the same partition.
NonOverlappingSingleSubscription The filtering for the article yields non-overlapping partitions that are unique for each subscription.
Overlapping The filtering for the article either is static or does not yield a unique subset of data for each partition, that is, an "overlapping" partition.
OverlappingDisallowOutOfPartitionDml The partitions are overlapping, and data manipulation language (DML) updates made at the Subscriber cannot change the partition to which a row belongs.

Osservazioni

If the source table for an article is already published in another publication, then the value of PartitionOptions must be the same for both articles.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Piattaforme

Piattaforme di sviluppo

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Piattaforme di destinazione

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Vedere anche

Riferimento

Microsoft.SqlServer.Replication Namespace
MergeArticle Class

Altre risorse

Filtri di riga con parametri