Database Status Constants (SQLDMO_DBSTATUS_TYPE)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Constant	Value	Description
SQLDMODBStat_All	34784	Combines all database status constants by using an OR logical operator.
SQLDMODBStat_EmergencyMode	32768	Indicates emergency mode has been initiated on the referenced database.
SQLDMODBStat_Inaccessible	992	Combines the constants SQLDMODBStat_Loading, SQLDMODBStat_Offline, SQLDMODBStat_Recovering, and SQLDMODBStat_Suspect by using an OR logical operator.
SQLDMODBStat_Loading	32	Indicates that database loading is in progress on the referenced database.
SQLDMODBStat_Normal	0	Indicates that the referenced database is available for use.
SQLDMODBStat_Offline	512	Indicates that the referenced database has been placed offline by a system or user action.
SQLDMODBStat_Recovering	192	Indicates that database recovery is in process on the referenced database.
SQLDMODBStat_Standby	1024	Indicates that the referenced database is defined on a standby server.
SQLDMODBStat_Suspect	256	Indicates that database integrity is suspect for the referenced database.