Dela via


UserOptions.ImplicitTransactions Property

Gets or sets the Boolean property value that specifies whether a Transact-SQL transaction is started automatically after the previous transaction is committed or rolled back.

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,  _
    "true")> _
Public Property ImplicitTransactions As Boolean
    Get
    Set
'Usage
Dim instance As UserOptions
Dim value As Boolean

value = instance.ImplicitTransactions

instance.ImplicitTransactions = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "true")]
public bool ImplicitTransactions { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Deploy, 
    L"true")]
public:
property bool ImplicitTransactions {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "true")>]
member ImplicitTransactions : bool with get, set
function get ImplicitTransactions () : boolean
function set ImplicitTransactions (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies the whether new transactions are started automatically after transaction commit or rollback statements.
If True, transactions are started automatically after a commit or rollback.
If False (default), transactions must be started explicitly using the BEGIN TRANSACTION syntax.