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

The information in this article 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.

Modification Type:	Major	Last Reviewed:	10/3/2003
Keywords:	kbBug kbpending KB253149