共用方式為


UserOptions.AbortTransactionOnError 屬性

Gets or sets the Boolean property value that specifies whether transactions are automatically terminated or not.

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Deploy,  _
    "false")> _
Public Property AbortTransactionOnError As Boolean 
    Get 
    Set
'用途
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)

屬性值

型別: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.

備註

Use this option if you want to handle errors programmatically.

範例

在 SMO 中設定 SQL Server

請參閱

參考

UserOptions 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

在 SMO 中設定 SQL Server

NIB user options 選項