FileGrowthType Property
Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The FileGrowthType property specifies the method of incremental allocation applied when an operating system file is extended.
Sintassi
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. |
Osservazioni
Set both the FileGrowthType and FileGrowth properties to completely specify the growth increment.