SpaceAvailable 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 SpaceAvailable property returns the amount of disk resource allocated and unused in operating system files implementing Microsoft SQL Server database and database transaction log storage.

Syntax

object
.SpaceAvailable 

Parts

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

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetSpaceAvailable(LPLONG pRetVal);

Remarks

The return value of SpaceAvailable represents a number of kilobytes.

Applies To:

Database Object

TransactionLog Object