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.