Status Property (Services)

Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

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.

Applies To:

FullTextService Object

SQLServer Object

JobServer Object