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)

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Deploy, 
public bool ImplicitTransactions { get; set; }

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.

Return to top