FIX: 702 Error on Update with Over 132 ANDs

Last reviewed: April 29, 1997
Article ID: Q103063

The information in this article applies to:

Microsoft SQL Server version 4.2 for OS/2
Microsoft SQL Server, versions 4.21 and 4.21a

BUG# OS/2: 1743 (4.2)

       NT:  383 (4.2)

SYMPTOMS

SQL statements that have a large number of AND expressions in their WHERE clauses (typically over 132 ANDs) can produce error 702:

   Memory request for nnnnn bytes exceeds the size of single
   page of 2048 bytes.

WORKAROUND

This error indicates that part of the execution plan for the update has exceeded an internal resource in SQL Server. Recode the query to have fewer conditions connected with an AND expression.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2 and Microsoft SQL Server versions 4.21 and 4.21a. This problem was corrected in SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: Transact-SQL
Keywords : kbbug4.20 kbbug4.21 kbbug4.21a kbfix6.00 kbprg SSrvServer
Version : 4.2 | 4.21 4.21a
Platform : OS/2 WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.