SpaceAvailableInMB Property (SQL-DMO)

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.

Applies To
Database Object TransactionLog Object
DBFile Object  

Syntax

object.SpaceAvailableInMB

Part Description
object Expression that evaluates to an object in the Applies To list

Remarks

The return value of SpaceAvailableInMB represents a number of megabytes.

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);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.