Status Property (Database)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The Status property returns component execution or integrity state information.

Syntax

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: