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.
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