• Article

MergePublication.AutomaticReinitializationPolicy Property

Gets or sets whether changes at the Publisher are uploaded to the Publisher when a subscription is reinitialized because of a change in the publication.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public Property AutomaticReinitializationPolicy As AutomaticReinitializationPolicies
    Get
    Set
'Usage
Dim instance As MergePublication
Dim value As AutomaticReinitializationPolicies

value = instance.AutomaticReinitializationPolicy

instance.AutomaticReinitializationPolicy = value

public AutomaticReinitializationPolicies AutomaticReinitializationPolicy { get; set; }

public:
property AutomaticReinitializationPolicies AutomaticReinitializationPolicy {
    AutomaticReinitializationPolicies get ();
    void set (AutomaticReinitializationPolicies value);
}

member AutomaticReinitializationPolicy : AutomaticReinitializationPolicies with get, set

function get AutomaticReinitializationPolicy () : AutomaticReinitializationPolicies
function set AutomaticReinitializationPolicy (value : AutomaticReinitializationPolicies)

Remarks

The AutomaticReinitializationPolicy property can be retrieved by members of the db_owner or replmonitor fixed database roles on the publication database or by members of the publication access list (PAL) for the publication.

The AutomaticReinitializationPolicy property can be set by members of the sysadmin fixed server role at the Publisher. It can also be set by members of the db_owner fixed database role on the publication database.

Retrieving AutomaticReinitializationPolicy is equivalent to executing sp_helpmergepublication.

Setting AutomaticReinitializationPolicy is equivalent to executing sp_addmergepublication or sp_changemergepublication.

The AutomaticReinitializationPolicy property is available with Microsoft SQL Server 2005 only.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.