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)
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
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.
Hi Pinal
is there any solution for this error if it is occured in sql server 2008 ?
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.
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”