Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
A severe error occurred on the current command. The results, if any, should be discarded.

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

  • Sunday, December 30, 2012 10:48 AM
     
      Has Code
    Sign In to Vote
    0

    on an sql server instance (version: 10.0.1600.22) i have a table which has no pk no index no constraint no key with several columns.

    when I execute the following commands in management studio, i get the error: "A severe error occurred on the current command.  The results, if any, should be discarded." 

    SELECT * FROM mySchema.MyTable
SELECT * FROM mySchema.MyTable where id = 203679
SELECT sum(col1) FROM mySchema.MyTable
delete mySchema.MyTable where id = 203679

    However the following sql commands executed properly without error

    select * from mySchema.MyTable where id <> 203679
    select  ID from mySchema.MyTable where id = 203679
    DBCC CHECKtable('mySchema.MyTable')
    DBCC CHECKDB(MyDB)

    what should i do?

     

All Replies

  • Sunday, December 30, 2012 11:34 AM
     
     
    Sign In to Vote
    0

    Hi,

    You see that because :

    1. Session has crashed.

    2.Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing" message

    See discussion on blow URL:

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36409

    Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/



    • Edited by Ahsan Kabir Sunday, December 30, 2012 11:36 AM
    • Edited by Ahsan Kabir Sunday, December 30, 2012 11:40 AM
    •  
     
  • Sunday, December 30, 2012 12:15 PM
    Answerer
     
     
    Sign In to Vote
    0
    Looks like a bug, can you install latest service pack (SP3 IIRW)

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

     
  • Sunday, December 30, 2012 1:01 PM
     
     Answered
    Sign In to Vote
    0

    So the error indicates that there was a crash either in the server or in the client API. If the problem is in the server, you should find a stack dump in the SQL Server error log. To determine if the error is on the client side, try running the same commands from SQLCMD that uses OLE DB, in difference to SSMS that uses SqlClient.

    Since you have the RTM version of SQL 2008, my recommendation is that you install Service Pack 3 to see if this resolves the issue, before you make any other investigations.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
     
  • Sunday, December 30, 2012 2:35 PM
     
     
    Sign In to Vote
    0

    Hi,

    Thank you for your suggestion, I installed SQL2008 SP2 and the problem was solved.

    Unfortunately, I did not restart the server before installing SP2. So, I'm not sure if restarting the server or installing SP2 solved the problem.

    Regards,

    Shahyad

     
  • Sunday, December 30, 2012 3:16 PM
     
      Has Code
    Sign In to Vote
    0
     
    Hi Shahyad,
    there is no from command in delete command in following SQL script.  Can you add the from command in it to have a try.
    SELECT * FROM mySchema.MyTable
SELECT * FROM mySchema.MyTable where id = 203679
SELECT sum(col1) FROM mySchema.MyTable
delete mySchema.MyTable where id = 203679

    • Edited by Presley Shi Sunday, December 30, 2012 3:17 PM
    •