Why do I get an error "Error: 702, Severity: 20, State: 1" running a SQL Server query?

A. The full error for this continues "Memory request for 2928 bytes exceeds the size of single page of 2044
bytes." This error only affects SQL 6.5 and below.

This is a SQL bug and cannot be fixed other than by rewriting the query in a different way - there is no way to expand SQL's page size.

Some reasons for this bug are already documented in http://support.microsoft.com - just search on 702 and SQL. If your problem does not match any of these and you have already applied the latest service pack then either post a reproduction script for an MVP to report for you or call the problem in to Microsoft PSS yourself.

===

v1.01 2000.02.01
Applies to SQL Server versions : 4.x, 6.x
Related FAQ articles : n/a
Related Microsoft Kb articles : n/a
Other related information : n/a