Microsoft KB Archive/141335

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

Article ID: 141335

Article Last Modified on 3/14/2005

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.