Microsoft SQL Server Temporary tables
Database stored procedures frequently contain temporary tables
that are used as repositories when accumulating rows during processing
within the procedure. Since versions of SQL Server prior to SQL
Server 2000 do not allow Data Definition Language (DDL) to be executed
within the scope of a transaction, PowerBuilder provides the boolean
AutoCommit property in the transaction object to allow you to handle
these cases.
When AutoCommit is false (the default), normal transaction
processing takes place: a BEGIN TRANSACTION is internally issued
on a successful connect and this transaction is terminated by a
COMMIT TRANSACTION or ROLLBACK TRANSACTION.
When AutoCommit is set to true, no transaction management
is performed. Therefore, stored procedures that create temporary
tables can be executed. This option should be used with great care
because of the recovery implications. If AutoCommit is true, ROLLBACK cannot be
issued.