• Article

ReplicationDatabase.HasPullSubscriptions Property

Gets whether or not the database has existing pull subscriptions.

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

Syntax

'Declaration
Public ReadOnly Property HasPullSubscriptions As Boolean
    Get
'Usage
Dim instance As ReplicationDatabase
Dim value As Boolean

value = instance.HasPullSubscriptions

public bool HasPullSubscriptions { get; }

public:
property bool HasPullSubscriptions {
    bool get ();
}

member HasPullSubscriptions : bool

function get HasPullSubscriptions () : boolean

Property Value

Type: System.Boolean
A Boolean value. If true, the database has at least one existing pull subscription. If false, the database has no existing pull subscriptions.

Remarks

The HasPullSubscriptions property can only be retrieved by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the replication database.

Retrieving HasPullSubscriptions is equivalent to executing sp_helpreplicationdboption (Transact-SQL).