Microsoft KB Archive/70835

PRSQL9103015: Referencing a Table Created in a Transaction ID Number: Q70835

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9103015

SYMPTOMS Referencing a table that was supposed to be created by a SELECT INTO statement inside of a BEGIN…COMMIT transaction will GP-fault SQL Server.

CAUSE A SELECT INTO statement is not allowed within a user-defined transaction.

RESOLUTION Create the table outside of the user-defined transaction. If the transaction fails, set the global variable @@error, and rollback the transaction. Then, outside of the transaction, check for the value of @@error, and drop the table if this value is set.