Status Property (TargetServer)

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The Status property returns component execution or integrity state information.

Sintaxis

object
.Status 

Parts

• object
  An expression that evaluates to an object in the Applies To list.

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetStatus(LPLONG pRetVal);

Returns

The Status property is returned as a bit-packed long. One or more of the following values can be returned.

Constant	Value	Description
SQLDMOTargetServerStatus_/Blocked	4	An instance of Microsoft SQL Server is visible. SQL Server Agent is blocked.
SQLDMOTargetServerStatus_/Normal	1	An instance of SQL Server is visible. SQL Server Agent is known to be running.
SQLDMOTargetServerStatus_/SuspectedOffline	2	An instance of SQL Server is visible. The execution state of SQL Server Agent cannot be determined.
SQLDMOTargetServerStatus_/Unknown	0	A network error is preventing determination of the state of the referenced server and SQL Server Agent.

Applies To:

TargetServer Object