Compartilhar via


FileGrowthType Property

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

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

Sintaxe

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.

Comentários

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