Status Property (Services)

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, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetStatus(SQLDMO_SVCSTATUS_TYPE* pStatus);

Returns

Interpret the Status property return value using these values.

Constant	Value	Description
SQLDMOSvc_Continuing	6	The service execution state is in transition from paused to running.
SQLDMOSvc_Paused	2	Service execution is paused.
SQLDMOSvc_Pausing	7	The service execution state is in transition from running to paused.
SQLDMOSvc_Running	1	The service is running.
SQLDMOSvc_Starting	4	The service execution state is in transition from stopped to running.
SQLDMOSvc_Stopped	3	The service is stopped.
SQLDMOSvc_Stopping	5	The service execution state is in transition from running to stopped.
SQLDMOSvc_Unknown	0	The service execution state could not be determined.

Applies To:

FullTextService Object	SQLServer Object
JobServer Object