FIX: AV if Subquery GROUP BY and HAVING with ROUND()

ID: Q154887

The information in this article applies to:

Microsoft SQL Server version 6.5

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          : kbprg SSrvProg kbbug6.50 kbfix6.50.sp2 
Version           : 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 1, 1999