AllowMergePublication 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 AllowMergePublication property returns TRUE if the referenced Microsoft SQL Server database can be published in merge replication.

Syntax

object
.AllowMergePublication

Parts

  • object
    An 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 if local or anonymous merge pull subscriptions target the referenced database.

When using SQL Distributed Management Objects (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, and then create the publication. Reestablish local or anonymous pull subscriptions after successful creation of the publication.