Bug #: 470138 (SQL Server 8.0) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Bug #: 470138 (SQL Server 8.0)

hey folks, I have found this error/bug in some of my user’s applications … Bug #: 470138 (SQL Server 8.0)
SYMPTOMS
When you run a Transact-SQL SELECT statement on a view that has many subqueries, you may receive an error message that is similar to the following: Server: Msg 8624, Level 16, State 21, Line 1
Internal SQL Server error.
I should say it doesnt happen exclusively with views, as I am also getting the internal error with any query with different nesting levels of SELECT. Microsoft recommends to WAIT until the next service pack release … mmmmmmmm Has anybody fixed this bug before??
Is that release expected to come out soon??
thx for ur answers
pep

According to the Microsoft KB you can contact Microsoft Product Support Services to obtain the hotfix. If you have confirmed issues resulting to this bug they will send you the hotfix for free.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;290817<br />this is the actual problem….<br /><br />and theres a workaround, as the symptoms are clear:: <br />"<br />If you submit a query that contains an aggregate or other computed column inside of a subquery, SQL Server may return error 8624 while attempting to optimize the query. The error message is: <br /><br />Server: Msg 8624, Level 16, State 8, Line 1<br />Internal SQL Server error. <br />"<br /><br />The workaround, in this case is<br /><br />WORKAROUND :: If the computed expression is a MIN(&lt;column&gt<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ /> or MAX(&lt;column&gt<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ /> aggregate, you can replace the aggregate with a TOP 1 &lt;column&gt; … ORDER BY &lt;column&gt; ASC or ORDER BY &lt;column&gt; DESC clause, respectively. <br />STATUS :: Microsoft has confirmed this to be a problem in SQL Server 2000.<br /><br />Yes, I should contact the MS Product support, but I have never done that before …. any clue?<br /><br />
http://support.microsoft.com/default.aspx?scid=fh;EN-GB;CNTACTMS this page refers about MS support in UK and you should check under MS Spanish region. Further I found this pagehttp://register.microsoft.com/contactus30/contactus.asp?domain=servers which refers abotu product support. HTH
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>