Status Property (Services)

Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.

The Status property returns component execution or integrity state information.

Sintassi

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