BUG: Sort Pages Option of 511 May Cause 702 Error on Non-Intel (141335)


The information in this article applies to:

  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
This article was previously published under Q141335
BUG #: 12343 (NT: 6.00)

SYMPTOMS

If the sp_configure parameter 'sort pages' is set to 511 on non-Intel platforms using SQL Server versions 6.0 or 6.5, queries with an ORDER BY clause can fail with a 702 error:
memory request for %d bytes exceeds the size of a single page of %d bytes.

WORKAROUND

To work around this problem, set the 'sort pages' option to 510 or less.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5.
Modification Type:MinorLast Reviewed:3/14/2005
Keywords:kbBug kbenv KB141335
©2004 Microsoft Corporation. All rights reserved.