Subscription.SubscriptionType Property
Gets whether the subscription registration is for a push or pull subscription.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Syntax
'Declaration
Public ReadOnly Property SubscriptionType As SubscriptionOption
Get
'Usage
Dim instance As Subscription
Dim value As SubscriptionOption
value = instance.SubscriptionType
public SubscriptionOption SubscriptionType { get; }
public:
property SubscriptionOption SubscriptionType {
SubscriptionOption get ();
}
member SubscriptionType : SubscriptionOption
function get SubscriptionType () : SubscriptionOption
Property Value
Type: Microsoft.SqlServer.Replication.SubscriptionOption
A SubscriptionOption value. If Push, the subscription is a push subscription.
Remarks
The SubscriptionType property is a read-only property.
In Microsoft SQL Server 2005, all subscriptions are tracked at the Publisher. Anonymous is never returned.
Use TransPullSubscription or MergePullSubscription to create a pull subscription. For more information, see NIB Create a Pull Subscription (RMO Programming).
The SubscriptionType property can only be retrieved by members of the sysadmin fixed server role at the Publisher, by members of the db_owner fixed database role on the publication database, or by the user that created the subscription.
Retrieving the SubscriptionType property is equivalent to executing sp_helpsubscription or sp_helpmergesubscription.