Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
IsVarDecimalStorageFormatEnabled Property
Collapse the table of content
Expand the table of content

Database.IsVarDecimalStorageFormatEnabled Property

Gets or sets a value that specifies whether VarDecimal storage is enabled.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy|SfcPropertyFlags.Matrix)]
public bool IsVarDecimalStorageFormatEnabled { get; set; }

Property Value

Type: Boolean
A Boolean value that specifies whether VarDecimal storage format is enabled. True if the VarDecimal storage is enabled; otherwise, false.

VarDecimal storage format cannot be disabled while any tables in the database are using it.

Community Additions

ADD
Show:
© 2015 Microsoft