Post reply

DBCC CHECKDB - consistency errors (8992)

  • August 27, 2008 at 10:33 am

    #130996

    Hello

    I am receiving consistency errors in the results of the DBCC Checkdb.

    Msg 8992, Level 16, State 1, Line 1

    Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1849018314,referenced_minor_id=1) of row (class=0,object_id=1836546322,column_id=0,referenced_major_id=1849018314,referenced_minor_id=1) in sys.sql_dependencies does not have a matching row (object_id=1849018314,column_id=1) in sys.columns.

    In the past, when I have received these errors I have been able to determine what object(s) is causing them using the following Query:

    select distinct name,type from sys.sql_dependencies

    LEFT JOIN sys.objects on sys.sql_dependencies.object_id = sys.objects.object_id

    where sys.sql_dependencies.object_id = 1849018314 (referenced_major_id #)

    I then can script out the object, drop it , and recreate it. The error message is resolved the next time I run CHECKDB.

    This time however I am unable to determine which object is causing the problem. The results from the previous query return no records from the sysobjects table. It does not exist

    Is there anyway to remove these records if there is no object to depend on?

    Thanks

  • August 27, 2008 at 10:54 am

    #863880

    If this db has been upgraded from SQL2000 then check if you see the db_owner role:

    SELECT * FROM sys.database_principals

    from a little research the solution seems to be to copy all your users and objects to a new db.

    Alot of other users with the same problem referenced this post.

    http://www.webservertalk.com/message1281450.html

  • August 27, 2008 at 11:45 am

    #863900

    Thanks Todd

    It appears that the dbo role is valid.

    Unfortuantely the size of the database and the number of objects (keys,triggers,sp,tables,functions,views - > 30,000) does not lend itself for duplication. This db will need to be fixed.

    Any other suggestions would be appreciated.

  • August 27, 2008 at 1:31 pm

    #863947

    select from sys.objects where the object_id

    what does it return for this?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • August 27, 2008 at 1:35 pm

    #863949

    In other databases this has returned the object name (function, sp,etc..) This time is not returning anything. 0 records.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply