SQLServer Object
Gets or sets the refetch interval for retrieiving the Status and SpaceAvailable properties for all Database objects in the SQLServer.Databases collection.
lRefetchInterval = SQLServer.StatusInfoRefetchInterval ( [StatusInfoType :=] tStatusInfo )
SQLServer.StatusInfoRefetchInterval ( [StatusInfoType :=] tStatusInfo ) = lRefetchInterval
HRESULT pSQLServer->GetStatusInfoRefetchInterval (
SQLOLE_STATUSINFO_TYPE tStatusInfo,
LPLONG plRefetch );
HRESULT pSQLServer->SetStatusInfoRefetchInterval (
SQLOLE_STATUSINFO_TYPE tStatusInfo,
long lRefetch );
Element | Type | Description |
---|
lRefetchInterval | Long | Refetch interval in seconds |
tStatusInfo | SQLOLE_STATUSINFO_TYPE | Status information to set or get |
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.