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

running following query in sql server management studio gives error below.

update table_name set is_active = 0 id  = 3 

a severe error occurred on current command. results, if any, should discarded.

• the logs have been truncated
• there update trigger isnt issue
• the transaction count 0 (@@trancount)

i have tried same update statement on couple of other tables in database , work fine.

dbcc checktable('table_name'); 

gives

dbcc results 'table_name'. there 13 rows in 1 pages object "table_name". dbcc execution completed. if dbcc printed error messages, contact system administrator. 

i had same error, , down corrupted index. re-indexing table fixed problem.

i realise thread year old, thought worth mentioning incase comes across in future (like did).