FileGrowth 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 FileGrowth property specifies the growth increment of the operating system file used to store table, index, or log data.
Syntax
object
.FileGrowth [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
A long integer
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetFileGrowth(LPLONG pRetVal);
HRESULT SetFileGrowth(LONG NewValue);
Remarks
The FileGrowth value is evaluated using the FileGrowthType property.
If FileGrowthType is SQLDMOGrowth_MB, the value represents the number of megabytes of disk space to allocate for incremental file growth.
If FileGrowthType is SQLDMOGrowth_Percent, the value represents a percentage and must be in the range from 1 through 100. Microsoft SQL Server never increments a file in units smaller than one megabyte, regardless of the result of the percentage of file size calculation.