Status Property (Services)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The Status property returns component execution or integrity state information.
Syntax
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. |