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

• Microsoft SQL Server version 6.5

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:

Q152053 : BUG: Error 7113 When Selecting into a Table

Keywords          : SSrvProg SSrvTran_SQL kbbug6.50 
Version           : WINNT:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 21, 1999