The information in this article applies to:
BUG #: 17089 (Windows NT: 6.5) SYMPTOMS
If an UPDATE trigger fires and contains an UPDATE that joins with the
inserted table, the following error may occur if SET FORCEPLAN is set ON
and the sysindexes count for syslogs number of pages is high:
WORKAROUND
To work around this problem, look for ways to avoid using SET FORCEPLAN ON
with UPDATE statements including proper index design.
STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5.
This problem was corrected in the latest Microsoft SQL Server 6.5 U.S.
Service Pack. For information on obtaining the service pack, query on
the following word in the Microsoft Knowledge Base (without the spaces):
MORE INFORMATION
The following is a summary of the conditions that cause the problem to
occur:
Keywords : kbusage SSrvTran_SQL kbbug6.50 kbfix6.50.sp4 |
Last Reviewed: April 16, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |