DistributionSubscription.SubscriptionType Property

Gets or sets whether the Distribution agent runs at the Distributor (Push) or at the Subscriber (Pull).

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

Syntax

'Declaration
Public Property SubscriptionType As SubscriptionOption 
    Get 
    Set
'Usage
Dim instance As DistributionSubscription 
Dim value As SubscriptionOption 

value = instance.SubscriptionType

instance.SubscriptionType = value

public SubscriptionOption SubscriptionType { get; set; }

public:
property SubscriptionOption SubscriptionType {
    SubscriptionOption get ();
    void set (SubscriptionOption value);
}

member SubscriptionType : SubscriptionOption with get, set

function get SubscriptionType () : SubscriptionOption 
function set SubscriptionType (value : SubscriptionOption)

Property Value

Type: Microsoft.SqlServer.Replication.SubscriptionOption
The type of subscription.

Remarks

This property cannot be set for an existing subscription.

The SubscriptionType property can only be retrieved by members of the db_owner fixed database role on the distribution database.

The SubscriptionType property can be set by any user.

See Also

Reference

DistributionSubscription Class

Microsoft.SqlServer.Replication Namespace