Status Property (Database)

この機能は、将来のバージョンの 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_DBSTATUS_TYPE* pRetVal);

Returns

Interpret the Status property return value using these values.

Constant

Value

Description

SQLDMODBStat_All

34784

All database status constants are combined by using an OR logical operator.

SQLDMODBStat_/EmergencyMode

32768

Emergency mode has been initiated on the referenced database.

SQLDMODBStat_Inaccessible

992

SQLDMODBStat_Loading, SQLDMODBStat_Offline, SQLDMODBStat_Recovering, and SQLDMODBStat_Suspect are combined using an OR logical operator.

SQLDMODBStat_Loading

32

Database loading is in progress on the referenced database.

SQLDMODBStat_Normal

0

The referenced database is available for use.

SQLDMODBStat_Offline

512

The feferenced database has been placed offline by a system or user action.

SQLDMODBStat_Recovering

192

Database recovery is in progress on the referenced database.

SQLDMODBStat_Standby

1024

The referenced database is defined on a standby server.

SQLDMODBStat_Suspect

256

Database integrity is suspect for the referenced database.

Applies To: