SpaceAllocatedOnFiles 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 SpaceAllocatedOnFiles property returns the total disk resource allocated for transaction log implementing files.

Syntax

object.SpaceAllocatedOnFiles(Database)

Parts

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

• Database
  A string that identifies a Microsoft SQL Server database by name

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetSpaceAllocatedOnFiles(SQLDMO_LPCSTR strDatabase,LPLONG pRetVal);

Remarks

The return value of SpaceAllocatedOnFilesrepresents a number of kilobytes.

Applies To:

TransactionLog Object