ReplicationDatabase.HasPublications Property

Article
12/03/2008

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

public bool HasPublications { get; }

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

/** @property */
public boolean get_HasPublications ()

public function get HasPublications () : boolean

Property Value

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

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via