Running the following query in Management studio
update table_name set is_active = 0 where id = 3
gives the following error,
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
- The logs have been truncated
- there is an update trigger but this isnt the issue
- the transaction count is zero (@@trancount)
I have tried the same update statement on a couple of other tables in the database and they work fine.
Any ideas?
Update
DBCC CHECKTABLE('table_name');
gives
DBCC results for 'table_name'.
There are 13 rows in 1 pages for object "table_name".
DBCC execution completed. If DBCC printed error messages, contact your system administrator.