Wednesday, March 7, 2012

Error using QA

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
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
>
|||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:
>
>
|||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:
[vbcol=seagreen]
>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:
>
|||Perhaps you may want to check the KBAs : 290817, 317527 & 286249
Anith

No comments:

Post a Comment