FIX: AV if Subquery GROUP BY and HAVING with ROUND() (154887)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbfix kbProgramming KB154887 |
|---|
|