Status Information Constants (SQLDMO_STATUSINFO_TYPE)

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.

Status information constants direct SQL Distributed Management Objects (SQL-DMO) interpretation of the StatusInfoRefetchInterval property of the SQLServer object.

When an application connects a SQLServer object to an 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. It set all values equal.
SQLDMOStatInfo_/AutoVerifyConnection	4	An interval for testing a broken connection.
SQLDMOStatInfo_/DatabaseSpace	2	An interval for retrieving space available in databases referenced by Database objects active in the application.
SQLDMOStatInfo_/DatabaseStatus	1	An interval for retrieving database status information visible in the Status property of Database objects active in the application.
SQLDMOStatInfo_Unknown	0	The value is not valid.