Status Property (Database)
TOC
Collapse the table of content
Expand the table of content

Status Property (Database)

SQL Server 2008 R2

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.


object
.Status 

object

An expression that evaluates to an object in the Applies To list.

Long, enumerated

Read-only

HRESULT GetStatus(SQLDMO_DBSTATUS_TYPE* pRetVal);

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.

Community Additions

ADD
Show:
© 2016 Microsoft