The information in this article applies to:
SYMPTOMS
Inserting into a table with a text column of more than 1800 characters,
which fires a trigger containing a delete followed by an insert on the same
table, causes error 7113:
For example, the following table and trigger are created:
Inserting a row with the text column containing more than 1800 bytes will fail with the error 7113. WORKAROUNDTo workaround this problem, swap the order of the DELETE and INSERT clauses in the trigger. Depending on the situation, you may need to add or modify the WHERE clauses to make sure that swapping the order does not affect the correctness of the query. STATUSMicrosoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2 and Microsoft SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. Additional query words: Windows NT
Keywords : kbprg kbbug4.20 SSrvServer SSrvWinNT |
Last Reviewed: March 19, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |