Database Status Constants (SQLDMO_DBSTATUS_TYPE)

Use database status constants to interpret the return value of the Status property of the Database object.

Constant Value Description
SQLDMODBStat_All 34784 All database status constants combined by using an Or
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

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.