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.

Applies To:

DBFile Object

LogFile Object