FIX: Multiple ORDER BY DESC May Cause 614 Errors |
Q137432
A query with multiple ORDER BY <col> DESC clauses may get a 614 error:
A row on page X was accessed that has an illegal length of Y in database Z.
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 2 for SQL Server version 6.0. For more information, contact your primary support provider.
If the table has had data in it but is currently empty, it is possible for a query against that table with multiple ORDER BY <col> DESC clauses to get 614 errors. The ORDER BY columns should also be such that it is a "covered" query; that is, there is an index that can be used for the ORDER BY columns.
Additional query words: sql6 614 windows nt sort
Keywords : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600
|
Last Reviewed: March 30, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |