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. |