Condividi tramite

  • Articolo

Proprietà Status

Gets the Publisher status.

Spazio dei nomi  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Sintassi

'Dichiarazione
Public ReadOnly Property Status As State
    Get
'Utilizzo
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

Valore proprietà

Tipo: 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.

Osservazioni

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.