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.