DynamicFilters Property

SQL-DMO

SQL-DMO

DynamicFilters Property

The DynamicFilters property exposes filter clause interpretation for the referenced merge replication publication.

Applies To
MergePublication Object
Syntax

object.DynamicFilters [= value]

Parts

object

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 GetDynamicFilters(LPBOOL pRetVal);

HRESULT SetDynamicFilters(BOOL NewValue);

Remarks

When TRUE, the publication is filtered dynamically.

When FALSE (default), the publication is not filtered dynamically.

Note  If an application sets DynamicFilters after the initial snapshot has been created, a new snapshot must be generated and reapplied to each subscription. Snapshots are applied when the next scheduled snapshot and merge agent run.