Status Property (Database)
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The Status property returns component execution or integrity state information.
Sintaxis
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. |