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.