Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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: System.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.

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

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft