SQL SERVER – 2005 – FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: “A severe error occurred on the current command”

In SQL Server 2005 while testing Indexes I had created a table with one non clustered index only. I did not create any clustered index on table. After that I ran SELECT statement, it gave me following error. I was very surprised when I looked at error. It says Msg 0, what it means is that this error is not known error to Microsoft and it might be bug.

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.


I did search on error and found that it is definitely bug and there is Cumulative update package 6 for SQL Server 2005 Service Pack 2, which fixes this problem. You can download the Cumulative update package 6 for SQL Server 2005 Service Pack 2 from here.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the cumulative update package. To submit an online request to obtain the cumulative update package, visit the following Microsoft Web site: http://go.microsoft.com/?linkid=6294451

I hope my this finding will help users who have faced similar situation on production server.

Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL Error Messages, SQL Index
Previous Post
SQLAuthority News – Download SQL Server 2008 February CTP (CTP 6)
Next Post
SQL SERVER – UDF to Return a Calendar for Any Date for Any Year

Related Posts

5 Comments. Leave new

  • Hello Dave,

    Can You explain what exactly you done with little more detail. B’coz I did the same thing and I didn’t get that error

    Reply
  • Hi Pineal,

    I am facing this issue with SQL server 2008.

    Whenever i Try to execute dbcc shrinkfile, I am getting this error:

    A severe error occurred on the current command. The results, if any, should be discarded.

    Please help me.

    Reply
  • Hi Pinal
    is there any solution for this error if it is occured in sql server 2008 ?

    Reply
  • declare @p1 int
    set @p1=0
    declare @p3 int
    set @p3=8
    declare @p4 int
    set @p4=8193
    declare @p5 int
    set @p5=0
    exec sp_cursoropen @p1 output,N’ EXEC sfsp_login ”deneme_user”,”sfr_pss” ‘,@p3 output,@p4 output,@p5 output
    select @p1, @p3, @p4, @p5

    when i run this query sql server 2008 r2 error is;
    Executing SQL directly; no cursor.
    Msg 0, Level 11, State 0, Line 0
    A severe error occurred on the current command. The results, if any, should be discarded.

    but i have run this sql server 2005, command success.

    what is the problem about 2008 ?

    thnks.

    Reply
  • Mathew M Mathew
    March 3, 2013 9:24 am

    Hi ,
    I have the same errors , but when i return the value after commit i was getting error , so in the @@ERROR and return the value , then it executed fine
    IF @@ERROR 0 GOTO ERROR_SHOW

    SET @p_errormsg =”;
    SET @p_errocode =’0′;
    return (@p_result)

    — SO i doubt ,its a “NOT A BUG”

    Reply

Leave a Reply

Menu
Exit mobile version