共用方式為


Status Property (Services)

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。

The Status property returns component execution or integrity state information.

語法

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.