Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have got the Following Error When i ran the checkDB over the database. What are the steps can be taken to resolve the issue. Without affecting the users.

Msg 8992, Level 16, State 1, Line 2
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=645577338,referenced_minor_id=7) of row (class=0,object_id=821577965,column_id=0,referenced_major_id=645577338,referenced_minor_id=7) in sys.sql_dependencies does not have a matching row (object_id=645577338,column_id=7) in sys.columns.
Msg 8992, Level 16, State 1, Line 2
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=757577737,referenced_minor_id=7) of row (class=0,object_id=821577965,column_id=0,referenced_major_id=757577737,referenced_minor_id=7) in sys.sql_dependencies does not have a matching row (object_id=757577737,column_id=7) in sys.columns.

What are the steps can be taken to resolve the issue. Without affecting the users?

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

Take a look at the following KB article: "Msg 8992" error message and inconsistent metadata in the SQL Server system catalogs

It looks like you have an inconsistency in the sys.sql_dependencies system catalog view. As per the above KB article you can do one of two things to resolve this:

  1. Restore a backup that doesn't have the current inconsistency
  2. Create a new database and move all of the objects and data into the new database

Please see the above referenced KB article for further details.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.