SQL-DMO
SpaceAvailableInMB Property
The SpaceAvailableInMB property returns the amount of disk resource allocated and unused in operating system files implementing Microsoft® SQL Server™ 2000 database and database transaction log storage.
Applies To
Database Object | TransactionLog Object |
DBFile Object |
Syntax
object.SpaceAvailableInMB
Parts
object
Expression that evaluates to an object in the Applies To list
Data Type
Float, for Database and TransactionLog objects. The figure is accurate to two decimal places.
Long, for DBFile object.
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetSpaceAvailableInMB(LPLONG pRetVal);
Or
HRESULT GetSpaceAvailableInMB(LPFLOAT pRetVal);
Remarks
The return value of SpaceAvailableInMB represents a number of megabytes.