Status Property (Services) (SQL-DMO)

The Status property returns component execution or integrity state information.

Applies To
FullTextService Object SQLServer Object
JobServer Object  

Syntax

object.Status

Part Description
object Expression that evaluates to an object in the Applies To list

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

Data Type

Long, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetStatus(SQLDMO_SVCSTATUS_TYPE* pStatus);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.