Freigeben über


FileGrowthType Property

Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The FileGrowthType property specifies the method of incremental allocation applied when an operating system file is extended.

Syntax

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.

Hinweise

Set both the FileGrowthType and FileGrowth properties to completely specify the growth increment.

Applies To:

DBFile Object

LogFile Object