Status Information Constants (SQLDMO_STATUSINFO_TYPE)

SQL-DMO

SQL-DMO

Status Information Constants (SQLDMO_STATUSINFO_TYPE)

Status information constants direct SQL-DMO interpretation of the StatusInfoRefetchInterval property of the SQLServer object.

When an application connects a SQLServer object to a instance of Microsoft® SQL Server™, SQL-DMO automates retrieval of some status information allowing application action based on changes in status for some SQL Server components. For more information about controlling automated status information retrieval, see StatusInfoRefetchInterval Property.

Constant Value Description
SQLDMOStatInfo_All 7 Used when setting StatusInfoRefetchInterval only. Set all values equal.
SQLDMOStatInfo_AutoVerifyConnection 4 Interval for testing broken connection.
SQLDMOStatInfo_DatabaseSpace 2 Interval for retrieving space available in databases referenced by Database objects active in the application.
SQLDMOStatInfo_DatabaseStatus 1 Interval for retrieving database status information visible in the Status property of Database objects active in the application.
SQLDMOStatInfo_Unknown 0 Bad or invalid value.