Re: Error using QA

From: Steve Kass (skass_at_drew.edu)
Date: 07/01/04 

Date: Thu, 01 Jul 2004 11:28:33 -0400

Stefaan,

1. What result do you get from

  select @@version

?

2. The following produces no error for me:

select count(*) from Northwind..Orders
select(select count(*) from Northwind..Orders) as a

so I can only assume that your actual query is more than a simple select
from a single table. Can you post the actual query?

SK

Stefaan Dewulf wrote:

>When I run the sql:
>
>select count(*) ... I get the counter with no column name
>
>when I change the sql:
>select(select count(*) ...) as a
>
>Then I get the error message:
>
>Server: Msg 8624, Level 16, State 13, Line 1
>Internal SQL Server error.
>
>
>"Steve Kass" wrote:
>
>
>
>>Stefaan,
>>
>> This error is most often due to a bug. If you found a knowledge base
>>article that corresponds to your particular situation, the next step is
>>probably to contact Microsoft Product Support to request the hotfix. If
>>you want another opinion on whether you have actually encountered a bug,
>>in which case the normal product support fee would possibly be waived,
>>feel free to provide some information about what caused the error, and
>>also give the output you see when you run
>>
>>select @@version
>>
>>Steve Kass
>>Drew University
>>
>>Stefaan Dewulf wrote:
>>
>>
>>
>>>I keep getting the following error, but the sql is OK.
>>>I found something about the problem on the support site
>>>but did not find the hot fix.
>>>
>>>Server: Msg 8624, Level 16, State 13, Line 1
>>>Internal SQL Server error.
>>>
>>>Please help,
>>>Stefaan
>>>
>>>
>>>
>>>
>>
>>

Relevant Pages

  • Re: Error using QA
    ... When I run the sql: ... > This error is most often due to a bug. ... > probably to contact Microsoft Product Support to request the hotfix. ... >>Internal SQL Server error. ...
    (microsoft.public.sqlserver.mseq)
  • Re: WMP 11 Bug
    ... There's a particularly great article written about the 'cost of fixing one bug' that you can search for if you're interested. ... That's established by customer feedback to product support. ... That's even more scary because that means that even the most amateurish bugs in WMP won't get fixed, let alone the serious usability issues. ...
    (microsoft.public.windowsmedia)
  • Re: IS NULL not working in WHERE clause.
    ... At this point it's pretty hard to say whether it's a bug or corruption. ... And just to be certain - you said the query operators each select ... in the query plan that checks time_id for null, ... >This execution plan shows a single execution string. ...
    (microsoft.public.sqlserver.programming)
  • Re: union all
    ... It certainly seems like a bug to me if 8 million rows vanish when you ... Provide the CREATE TABLE statements for CLAIMFL, CHKREG, CLIENT, ... script below (with your query inserted) in Query Analyzer and posting ... >union all ...
    (microsoft.public.sqlserver.programming)
  • Re: A bug in MS Access
    ... I tried using exactly what you described, and received an error message that ... the delete query was invalid because it required a parameter. ... I do not believe you have a valid bug here. ... > I created a table ADDRESSDETAILS with following Columns ...
    (microsoft.public.access.modulesdaovba)