SQL Server error on update command - "A severe error occurred on the current command"

Solution 1:

I just had the same error, and it was down to a corrupted index. Re-indexing the table fixed the problem.

Solution 2:

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.

Solution 3:

Run DBCC CHECKTABLE('table_name');

Check the LOG folder where the isntance is installed (\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG usually) for any file named 'SQLDUMP*'

Solution 4:

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