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

    Question

  • 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?

    Sunday, December 30, 2012 10:48 AM

Answers

  • 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 1:01 PM

All replies

  • 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/



    Sunday, December 30, 2012 11:34 AM
  • 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 12:15 PM
    Answerer
  • 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 1:01 PM
  • 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 2:35 PM
  • 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
    Sunday, December 30, 2012 3:16 PM