AutoShrink Property (SQL-DMO)

The AutoShrink property exposes Microsoft® SQL Server™ sizing behavior for operating system files maintaining table and index data.

Applies To

DBOption Object

Syntax

object.AutoShrink [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	True or False

Remarks

If True, operating system files maintaining table and index data are evaluated for downward resizing when the server periodically checks for unused space.

If False, the operating system files storing the database are not evaluated during periodic checks for unused space.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetAutoShrink(LPBOOL pRetVal);

HRESULT SetAutoShrink(BOOL NewValue);