BUG: Error: 7109 While Processing TEXT Data in a DELETE TriggerID: Q195538
|
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.
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.
Microsoft has confirmed this to be a problem in SQL Server version 6.5.
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