Status Property (Database)
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The Status property returns component execution or integrity state information.
Syntaxe
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. |