AllowMergePublication Property

SQL-DMO

SQL-DMO

AllowMergePublication Property

The AllowMergePublication property returns TRUE when the referenced Microsoft® SQL Server™ database can be published in merge replication.

Applies To
ReplicationDatabase Object
Syntax

object.AllowMergePublication

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetAllowMergePublication(LPBOOL pRetVal);

Remarks

SQL Server merge publications cannot be created in a database currently configured as a target for a local or anonymous merge Subscriber-originated (pull) subscription. The AllowMergePublication property returns FALSE when local or anonymous merge pull subscriptions target the referenced database.

When using SQL-DMO to create merge publications, remove all local or anonymous pull subscriptions targeting the database by using the Remove method of the MergePullSubscription object, then create the publication. Re-establish local or anonymous pull subscriptions after successful creation of the publication.