• Article

DistributionPublisher.Status Property

Gets the Publisher status.

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

Syntax

'Declaration
Public ReadOnly Property Status As State
    Get
'Usage
Dim instance As DistributionPublisher
Dim value As State

value = instance.Status

public State Status { get; }

public:
property State Status {
    State get ();
}

member Status : State

function get Status () : State

Property Value

Type: Microsoft.SqlServer.Replication.State
A State value. Active means that the Publisher is using the Distributor. Inactive means that the Publisher is not using the Distributor.

Remarks

The Status property can only be retrieved by members of the sysadmin fixed server role at the Distributor.

Retrieving the Status property is equivalent to executing sp_helpdistpublisher.

The Status property is available with SQL Server 7.0, SQL Server 2000, and SQL Server 2005.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.