BUG: Sort Pages Option of 511 May Cause 702 Error on Non-IntelLast reviewed: February 2, 1998Article ID: Q141335 |
The information in this article applies to:
SYMPTOMSIf 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. WORKAROUNDTo work around this problem, set the 'sort pages' option to 510 or less.
STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
|
Additional query words: sql6 winnt sort setup
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |