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.