An extended transaction is a unit of work that has multiple Embedded SQL statements. In the Transact-SQL transaction mode, you surround an extended transaction statement with the begin transaction and commit transaction statements.
In the default ANSI mode, you are constantly within an extended transaction. When you issue a commit work statement, the current extended transaction ends and another begins. For details, see the Adaptive Server Enterprise Transact-SQL Users Guide.
Unless
the database option allow ddl in tran is set, do not
use the following Transact-SQL statements
in an extended, ANSI-mode transaction: alter database, create database, create
index, create table, create
view, disk init, grant, load
database, load transaction, revoke, truncate
table, and update statistics.
