Database inconsistency issues
Posted on 2014-02-14
When I run DBCC CHECKDB, I get a severe error.
When I run DBCC CHECKCATALOG, I get database inconsistency errors.
I googled and came across the following solution:
1. Start instance in single user mode.
2. Connect with DAC
3. sp_configure allow update on
4. edit sys.columns manually
My question is - how do I go about editing sys.columns manually? What are the steps, the SQL statements involved, etc.?