FileGrowth Property
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The FileGrowth property specifies the growth increment of the operating system file used to store table, index, or log data.
Sintaxis
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);
Notas
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.