Partilhar via

  • Artigo

Propriedade do RDL Status

Gets the Publisher status.

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

Sintaxe

'Declaração
Public ReadOnly Property Status As State
    Get
'Uso
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

Valor da propriedade

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.

Comentários

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.