SQL Server error on update command - "A severe error occurred on the current command"
I just had the same error, and it was down to a corrupted index. Re-indexing the table fixed the problem.
In my case,I was using SubQuery
and had a same problem. I realized that the problem is from memory leakage.
Restarting MSSQL
service cause to flush tempDb
resource and free huge amount of memory.
so this was solve the problem.
There are 3 possibilities on the MS KB
- 959028
- 910416
- 938102
When I see stuff like this: I always think hotfix, engine, server errors etc.
4 results: search for ""Msg 0, Level 11,State 0, Line 0" A severe error occurred on the current command"
Edit: It's on MS Connect too