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