Knowledge Base

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

Article ID: 141335

Article Last Modified on 3/14/2005

Microsoft SQL Server 6.0 Standard Edition
Microsoft SQL Server 6.5 Standard Edition

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.

Additional query words: sql6 winnt sort setup

Keywords: kbbug kbenv KB141335