The Status property returns component execution or integrity state information.
object.Status
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
Interpret the Status property return value using these values.
| Constant | Value | Description |
|---|---|---|
| SQLDMODBStat_EmergencyMode | 32768 | Emergency mode has been initiated on the referenced database |
| SQLDMODBStat_Inaccessible | 992 | SQLDMODBStat_ Loading, SQLDMODBStat_ Offline, SQLDMODBStat_ Recovering, and SQLDMODBStat_ Suspect combined by using an Or |
| SQLDMODBStat_Loading | 32 | Database loading is underway on the referenced database |
| SQLDMODBStat_Normal | 0 | Referenced database is available for use |
| SQLDMODBStat_Offline | 512 | Referenced database has been placed offline by a system or user action |
| SQLDMODBStat_Recovering | 192 | Database recovery is underway on the referenced database |
| SQLDMODBStat_Standby | 1024 | Referenced database defined on a standby server |
| SQLDMODBStat_Suspect | 256 | Database integrity is suspect for the referenced database |
Long, enumerated
Read-only
HRESULT GetStatus(SQLDMO_DBSTATUS_TYPE* pRetVal);