Microsoft KB Archive/154887

= FIX: AV if Subquery GROUP BY and HAVING with ROUND =

Article ID: 154887

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q154887





SYMPTOMS
A select that contains a subquery combined with a GROUP BY and a HAVING clause with the function ROUND results in the following error message and terminates with a thread level Access Violation (AV):

Msg 913, Level 22, State 2

Could not find row in Sysdatabases with database id 0.

Run DBCC CHECKTABLE on Sysdatabases.



WORKAROUND
Re-code the query so that it does not fit the pattern.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft SQL Server version 6.50.201. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: default

Keywords: kbbug kbfix kbprogramming KB154887

-

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

© Microsoft Corporation. All rights reserved.