Microsoft KB Archive/253149

= BUG: INSERT SELECT Operation of Text Field Modified Using UPDATETEXT Aborts Operation =

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:

getd_log: page 0x463 has no nextpage, objid=0x3ab91f56



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

-

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

© Microsoft Corporation. All rights reserved.