September 15, 2009 at 4:45 pm
I am getting this error when my application tries to execute an stored proc.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I looked into my SP and it has bunch of delete statements. I executed each delete statement one by one and caught one table that gives this error.
DELETE FROM TABLE WHERE FIELD = 'Something'
I have a clustered index on the table.I am not sure whether the Fix mentioned by MS is required as this has been working for last one year.No changes has been made to SQL Server environment.
September 15, 2009 at 8:23 pm
Many other people probably have more detailed knowledge of this than I do. However a few things I would ask/guess:
1) No changes to your SQL Server environment, but what about the database structure (indexes, table design, etc)?
2) I believe, if a clustered index is tied to the table, then anything column/data part of that clustered index cannot be dropped without first dropping the index.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
September 16, 2009 at 12:10 am
Run dbcc checktable on the table to see if there is any corruption with the table. If its a production environment run the command when there is very little load on the server.
"Keep Trying"
September 16, 2009 at 6:10 am
which Service pack ur server has. check the link:
http://dotnetwebprogramming.blogspot.com/2009/02/severe-error-occurred-on-current.html
🙂
September 18, 2009 at 7:32 am
Do Not click on the link from dba-vb. IE will start opening mulitple pages and become unresponsive. A reboot will be required.
September 18, 2009 at 7:47 am
lrosini (9/18/2009)
Do Not click on the link from dba-vb. IE will start opening mulitple pages and become unresponsive. A reboot will be required.
Was tempted to test that theory out. but doing a restore atm and decided against it 😛
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply