KeepPartitionChanges Property

后续版本的 Microsoft SQL Server 将删除该功能。 请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。

The KeepPartitionChanges property specifies whether a Publisher retains information about what data a Subscriber owns in a horizontally partitioned merge replication topology.

语法

object.KeepPartitionChanges [=value]

Parts

• object
  An expression that evaluates to an object in the Applies To list

• value
  TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetKeepPartitionChanges(LPBOOL pRetVal);
HRESULT SetKeepPartitionChanges(BOOL NewValue);

注释

In a horizontally partitioned merge replication topology, a Publisher retains information about deletes and updates. If the KeepPartitionChanges property is set to TRUE, the Publisher can determine which row belongs to which Subscriber. Only changes to rows belonging to a particular Subscriber are replicated.

For example, if the Subscriber is responsible only for tracking sales in northern Europe, rows updated at the Publisher will be kept in a special table so that the Subscriber only receives updated rows related to sales in northern Europe when the Subscriber and the Publisher synchronize. Setting KeepPartitionChanges to TRUE can result in improved performance because Subscribers only receive the necessary updates.

If KeepPartitionChanges is set to FALSE (default), no extra information about updates or deletes is kept at the Publisher.

注意
If an application calls KeepPartitionChanges on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.

Applies To:

MergePublication2 Object