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. |