DataFileSize 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 DataFileSize property exposes the size of a Microsoft SQL Server database used for replication distribution.

Syntax

object
.DataFileSize [=value]

Parts

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

• value
  A long integer that specifies a file size in megabytes.

Data Type

Long

Modifiable

Read/write if the DistributionDatabase object is used to create a replication distribution database. Read-only if a DistributionDatabase object references an existing SQL Server database.

Prototype (C/C++)

HRESULT GetDataFileSize(LPDWORD pRetVal);
HRESULT SetDataFileSize(DWORD NewValue);

Remarks

DataFileSize returns the current size of the primary file implementing a SQL Server replication distribution database.

Set DataFileSize to control the initial size of the database primary file created when using the DistributionDatabaseobject to create a SQL Server database for replication distribution.

Applies To:

DistributionDatabase Object