StatusInfoRefetchInterval Method

SQLServer Object

Description

Gets or sets the refetch interval for retrieiving the Status and SpaceAvailable properties for all Database objects in the SQLServer.Databases collection.

Visual Basic

lRefetchInterval = SQLServer.StatusInfoRefetchInterval ( [StatusInfoType :=] tStatusInfo )

SQLServer.StatusInfoRefetchInterval ( [StatusInfoType :=] tStatusInfo ) = lRefetchInterval

C++

HRESULT pSQLServer->GetStatusInfoRefetchInterval (
SQLOLE_STATUSINFO_TYPE tStatusInfo,
LPLONG plRefetch );

HRESULT pSQLServer->SetStatusInfoRefetchInterval (
SQLOLE_STATUSINFO_TYPE tStatusInfo,
long lRefetch );

Elements

Element Type Description

lRefetchInterval Long Refetch interval in seconds
tStatusInfo SQLOLE_STATUSINFO_TYPE Status information to set or get

Remarks

When the Status and SpaceAvailable properties are retrieved for one Database object, SQL-DMO retrieves and caches these properties for all Databases. If you get one of these properties within lRefetchInterval seconds after the last retrieval, the information from the cache will be used. If you get one of these properties more than lRefetchInterval seconds after the last retrieval, these properties of all Databases will be retrieved from SQL Server again. Setting lRefetchInterval to 0 disables this behavior. The default is 30 seconds.

This is an indexed property.