This documentation is archived and is not being maintained.

SpaceAvailableInMB Property

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.

The SpaceAvailableInMB property returns the amount of disk resource allocated and unused in operating system files implementing Microsoft SQL Server database and database transaction log storage.



An expression that evaluates to an object in the Applies To list

Float, for the Database and TransactionLog objects. The figure is accurate to two decimal places.

Long, for the DBFile object.


HRESULT GetSpaceAvailableInMB(LPLONG pRetVal);


HRESULT GetSpaceAvailableInMB(LPFLOAT pRetVal);

The return value of SpaceAvailableInMB represents a number of megabytes.