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).