UserOptions.AbortTransactionOnError Property
Gets or sets the Boolean property value that specifies whether transactions are automatically 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 AbortTransactionOnError As Boolean
Get
Set
'Usage
Dim instance As UserOptions
Dim value As Boolean
value = instance.AbortTransactionOnError
instance.AbortTransactionOnError = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy,
"false")]
public bool AbortTransactionOnError { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Deploy,
L"false")]
public:
property bool AbortTransactionOnError {
bool get ();
void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy,
"false")>]
member AbortTransactionOnError : bool with get, set
function get AbortTransactionOnError () : boolean
function set AbortTransactionOnError (value : boolean)
Property Value
Type: System.Boolean
A Boolean value that specifies the whether a transaction is automatically terminated and rolled back when an error occurs.If True, transactions are automatically terminated and rolled back when an error occurs.If False (default), transactions are not terminated when an error occurs; instead, a warning message is displayed and the transaction continues.
Remarks
Use this option if you want to handle errors programmatically.
Examples
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace