Microsoft KB Archive/253149

From BetaArchive Wiki
Knowledge Base

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

Article ID: 253149

Article Last Modified on 10/3/2003


  • Microsoft SQL Server 6.5 Service Pack 5a

This article was previously published under Q253149

BUG #: 18935 (SQLBUG_65)


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


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}


INSERT {Destination} SELECT {column list} FROM {TempTable}


Microsoft has confirmed this to be a problem in SQL Server 6.5 Service Pack 5a.

Keywords: kbbug kbpending KB253149