• Article

UserOptions.AbortOnArithmeticErrors Property

Gets or sets the Boolean property value that specifies whether arithmetic divide by zero errors are terminated or not.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Deploy,  _
    "false")> _
Public Property AbortOnArithmeticErrors As Boolean
    Get
    Set
'Usage
Dim instance As UserOptions
Dim value As Boolean

value = instance.AbortOnArithmeticErrors

instance.AbortOnArithmeticErrors = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "false")]
public bool AbortOnArithmeticErrors { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Deploy, 
    L"false")]
public:
property bool AbortOnArithmeticErrors {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "false")>]
member AbortOnArithmeticErrors : bool with get, set

function get AbortOnArithmeticErrors () : boolean
function set AbortOnArithmeticErrors (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies the whether a query is terminated when an arithmetic divide by zero occurs.
If True, queries are terminated when an arithmetic divide by zero error occurs.
If False (default), queries are not terminated when an arithmetic divide by zero error occurs; instead, a warning message is displayed and a Null value is assigned to the result of the arithmetic operation.