Article ID: 253149
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Service Pack 5a
This article was previously published under Q253149
BUG #: 18935 (SQLBUG_65)
SYMPTOMS
Execution of an INSERT SELECT statement, which transfers a TEXT/IMAGE field that has been modified using UPDATETEXT, may fail with a "Command has been aborted" error. The following message is logged in the error log:
WORKAROUND
Use SELECT...INTO to create a temporary table and then use SELECT...INSERT to move the data from the temporary table to the destination table. For example:
SELECT {column list} INTO {TempTable} FROM {Source}
-or-
INSERT {Destination} SELECT {column list} FROM {TempTable}
STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5 Service Pack 5a.
Keywords: kbbug kbpending KB253149