Microsoft KB Archive/154019

= BUG: Insert into Text Column with Trigger Causes Error 711 =

Article ID: 154019

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



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

-

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

© Microsoft Corporation. All rights reserved.