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).