Microsoft KB Archive/195538

= BUG: Error: 7109 While Processing TEXT Data in a DELETE Trigger =

Article ID: 195538

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q195538



BUG #: 18420 (SQLBUG_65)



SYMPTOMS
If you attempt to update a TEXT field in a table with a value greater than 1,800 characters in size by referencing the deleted table in a delete trigger, you receive the following error:

Msg 7109, Level 22, State 1

Unexpected log record of type 33 found while processing TEXT/IMAGE data.

The SQL Server is terminating this process.



WORKAROUND
To work around this problem, you can write a stored procedure that performs the insertion into table t2, before deleting records from t1. For an example, see the scenario in the MORE INFORMATION section of this article.



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5.



MORE INFORMATION
Consider the following scenario. There are 2 tables, t1 and t2. There is a delete trigger d1 defined on t1. Both the tables contain text fields. When a record is deleted from t1, a record must be inserted in t2 to indicate this deletion. The delete trigger initially inserts a record in t2 with a single blank for the text field. If you try to INSERT a value of more than 1,800 characters into the text field by referencing the deleted table in the trigger, you get the error 7113. However, if you try to UPDATE the text field with a value greater than 1,800 characters, you encounter error 7109.

For more information on error 7113, see the following article the Microsoft Knowledge Base:

152053 : BUG: Error 7113 When Selecting into a Table

Keywords: kbbug KB195538

-

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

© Microsoft Corporation. All rights reserved.