BUG: Insert into Text Column with Trigger Causes Error 711 (154019)


The information in this article applies to:

  • Microsoft SQL Server 6.5
This article was previously published under Q154019

SYMPTOMS

If you insert data into a table with a text column of more than 1,800 characters (which in turn fires a trigger containing a delete followed by an insert), all based on the same table and inserted, the following error message appears:
Msg 7113, Level 22, State 1

Datasize mismatch detected when transferring TEXT/IMAGE value. First
fragment page number XXX.
The SQL Server is terminating this process.

RESOLUTION

Do not use triggers on a table with a text column. If triggers are used, make sure that the text of the trigger does not include a delete operation, making use of insert, followed by an insert operation in the same trigger.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbbug kbfix kbnetwork KB154019
©2003 Microsoft Corporation. All rights reserved.