• Article

ReplicationDatabase.HasPublications Property

Gets whether or not the database has existing publications.

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

Syntax

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

value = instance.HasPublications

public bool HasPublications { get; }

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

member HasPublications : bool

function get HasPublications () : boolean

Property Value

Type: System.Boolean
A Boolean value. If true, the database has at least one existing publication. If false, the database has no existing publications.

Remarks

The HasPublications 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 HasPublications is equivalent to executing sp_helpreplicationdboption (Transact-SQL).