Compartir a través de


FileGrowthType Property

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The FileGrowthType property specifies the method of incremental allocation applied when an operating system file is extended.

Sintaxis

object
.FileGrowthType [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list.
  • value
    A long integer that specifies application of the FileGrowth property as described in Settings.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFileGrowthType(SQLDMO_GROWTH_TYPE* pRetVal);
HRESULT SetFileGrowthType(SQLDMO_GROWTH_TYPE NewValue);

Settings

Constant Value Description

SQLDMOGrowth_MB

0

The growth increment is interpreted as a size, in megabytes.

SQLDMOGrowth_Percent

1

The default. The growth increment is interpreted as a percentage of the space currently allocated.

Notas

Set both the FileGrowthType and FileGrowth properties to completely specify the growth increment.

Applies To:

DBFile Object

LogFile Object