AllowInteractiveResolver Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The AllowInteractiveResolverproperty specifies whether to allow subscriptions to invoke an interactive resolver when conflicts occur while data is being synchronized with an article.

AllowInteractiveResolver [= value]


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


A Boolean that specifies whether to allow subscriptions to use an interactive resolver



HRESULT GetAllowInteractiveResolver(LPBOOL pRetVal);
HRESULT SetAllowInteractiveResolver(BOOL NewValue);

Set the AllowInteractiveResolver property to TRUE to enable a subscription to use an interactive resolver to resolve conflicts while synchronizing with a merge article. If a custom resolver is specified using the ArticleResolver property, that custom resolver is invoked by the Microsoft Interactive Conflict Resolver. If ArticleResolver is not set, the default Microsoft SQL Server conflict resolver is used.

MergePullSubscription2 or MergeSubscription2 objects must also have the UseInteractiveResolver property set to TRUE.


If an application calls AllowInteractiveResolveron 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.

Community Additions