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 (http://blog.SQLAuthority.com)

About these ads

5 thoughts on “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”

  1. 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

  2. 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.

  3. 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.

  4. 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”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s