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 Transact-SQL User’s 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.
