FileGrowthType Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The FileGrowthType property specifies the method of incremental allocation applied when an operating system file is extended.
Syntax
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. |
Remarks
Set both the FileGrowthType and FileGrowth properties to completely specify the growth increment.