The information in this article applies to:
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:
WORKAROUNDTo 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. STATUSMicrosoft 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.
Q152053 : BUG: Error 7113 When Selecting into a Table
Keywords : SSrvProg SSrvTran_SQL kbbug6.50 |
Last Reviewed: April 21, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |