Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Database.NumericRoundAbortEnabled Property

Gets or sets a value that specifies whether the NUMERIC_ROUNDABORT database option is active.

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

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design|SfcPropertyFlags.Matrix)]
public bool NumericRoundAbortEnabled { get; set; }

Property Value

Type: Boolean
A Boolean value that specifies whether there is a loss of precision due to rounding in an expression causes an error. If True, an error is generated and no results are returned. If False (default), a warning is generated and a NULL is returned.

Implements

IDatabaseOptions.NumericRoundAbortEnabled

This option can also be changed by using the Transact-SQL ALTER DATABASE statement.

Community Additions

Show:
© 2015 Microsoft