共用方式為


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.

Applies To: