SQL-DMO
Status Property (Services)
The Status property returns component execution or integrity state information.
Applies To
| FullTextService Object | SQLServer Object |
| JobServer Object |
Syntax
object.Status
Parts
object
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 | Service execution state in transition from paused to running. |
| SQLDMOSvc_Paused | 2 | Service execution is paused. |
| SQLDMOSvc_Pausing | 7 | Service execution state in transition from running to paused. |
| SQLDMOSvc_Running | 1 | Service is running. |
| SQLDMOSvc_Starting | 4 | Service execution state in transition from stopped to running. |
| SQLDMOSvc_Stopped | 3 | Service is stopped. |
| SQLDMOSvc_Stopping | 5 | Service execution state in transition from running to stopped. |
| SQLDMOSvc_Unknown | 0 | Unable to determine service execution state. |