Knowledge Base

BUG: Insert into Text Column with Trigger Causes Error 711

Article ID: 154019

Article Last Modified on 10/3/2003

APPLIES TO

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.

Keywords: kbbug kbfix kbnetwork KB154019


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.