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.

Applies To:

Database Object