Re: Error using QA

From: Stefaan Dewulf (StefaanDewulf_at_discussions.microsoft.com)
Date: 07/01/04


Date: Thu, 1 Jul 2004 05:19:01 -0700

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
    ... Can you post the actual query? ... >Internal SQL Server error. ... >> This error is most often due to a bug. ... >>probably to contact Microsoft Product Support to request the hotfix. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Problem with XMLType indexing. Please confirm
    ... pasted your script verbatim into 10g release 10.1.0.2.0 personal on ... metalink for the bug fix. ... SQL> drop table bug; ... XMLType( ...
    (comp.databases.oracle.server)
  • RE: Undeclared tag ID % is used in a FOR XML Explicit Query
    ... As you have a test environment you should be able to test the change ... > In fact we have multiple SQL environment running the same config and Query, ... > on the SQL server running on Windows 2003. ... but is in fact a bug in SQL sever. ...
    (microsoft.public.sqlserver.programming)
  • Re: Quick Question
    ... but I'm not sure if it's a bug in SQL CE: ... Thanks for the information on RDA. ... >> Are there common reaons why a subscription would hang? ...
    (microsoft.public.sqlserver.ce)
  • Re: Bug in Database Maintenance Plans Enterprise Manager and MSDE v SQL
    ... Yep, this is a bug. ... Cannot Edit or Delete Database Maintenance Plan on MSDE Installation ... Looking for a SQL Server replication book? ... > The bug I am reporting is with the "Remove after X Weeks/Days" option for> Database Backup, Transaction Backup. ...
    (microsoft.public.sqlserver.msde)