Microsoft KB Archive/253149: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 49: | Line 49: | ||
== SYMPTOMS == | == SYMPTOMS == | ||
Execution of an '''INSERT SELECT''' statement, which transfers a '''TEXT'''/'''IMAGE''' field that has been modified using '''UPDATETEXT''', may fail with a | 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: | ||
<div class="errormessage"> | <div class="errormessage"> | ||
Latest revision as of 13:52, 21 July 2020
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