Microsoft KB Archive/67874

= PRB: SELECT INTO Fails Inside a User-Defined Transaction =

Article ID: 67874

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



This article was previously published under Q67874



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: kbprogramming KB67874

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.