PRB: SELECT INTO Fails Inside a User-Defined Transaction

• Microsoft SQL Server for OS/2, version 4.2
• Microsoft SQL Server version 4.2x

SYMPTOMS

The following message is received when a SELECT INTO is used inside a user-defined transaction:

SELECT INTO command not allowed within multi-statement transaction.

CAUSE

The SELECT INTO command is a nonlogged operation and is not allowed inside a user-defined transaction (BEGIN TRAN ... COMMIT TRAN).

WORKAROUND

If it is necessary to associate a table created with a SELECT INTO to a transaction, you can use the following method:

1. Create the table outside the user-defined transaction.



2. If the transaction fails, set the global variable @@error and roll back the transaction.



3. Outside the transaction, check for the value of @@error and drop the table if this value is set.

Additional query words: Transact-SQL Windows NT

Keywords : kbprg SSrvGen SSrvWinNT
Version : 4.2 | 4.2
Platform : OS/2 WINDOWS
Issue type :