Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/103063

From BetaArchive Wiki

FIX: 702 Error on Update with Over 132 ANDs

Q103063



The information in this article applies to:


  • Microsoft SQL Server version 4.2x



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.

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 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 : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2


Last Reviewed: January 4, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.