SQL-DMO
Status Property (Database)
The Status property returns component execution or integrity state information.
Applies To
| Database Object |
Syntax
Parts
object
Expression that evaluates to an object in the Applies To list
object.Status
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 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 combined using an OR logical operator. |
| 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. |