共用方式為


FileGrowthType Property

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。

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

語法

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.

備註

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