November 5, 2009 at 10:14 am
Hi Gail, I hope you can find it this time!
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=68247348,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=160771680,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=224771908,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=356248374,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=372248431,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=388248488,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=404248545,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=420248602,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=436248659,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=452248716,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=468248773,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=484248830,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=500248887,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=516248944,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=532249001,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=548249058,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=564249115,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=580249172,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=596249229,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=612249286,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1076250939,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1204251395,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1284251680,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1316251794,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1332251851,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1348251908,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1428252193,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1460252307,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1476252364,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1492252421,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1524252535,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1604252820,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1620252877,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=2119730654,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=224771908,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=356248374,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=372248431,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=388248488,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=404248545,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=420248602,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=436248659,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=452248716,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=468248773,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=484248830,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=500248887,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=516248944,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=532249001,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=548249058,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=564249115,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=580249172,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=596249229,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=612249286,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1076250939,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1268251623,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1284251680,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1316251794,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1396252079,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1460252307,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1604252820,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1620252877,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1451152215,referenced_minor_id=8) of row (class=0,object_id=1316251794,column_id=0,referenced_major_id=1451152215,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=1451152215,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1451152215,referenced_minor_id=8) of row (class=0,object_id=1284251680,column_id=0,referenced_major_id=1451152215,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=1451152215,column_id=8) in sys.columns.
CHECKDB found 0 allocation errors and 62 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 62 consistency errors in database 'hrptest'.
November 5, 2009 at 10:25 am
Ok, seen this one before. Not too serious.
Take a look at this blog post. If you can't solve based on what's posted there, post back and someone will hep more later.
http://sqlinthewild.co.za/index.php/2009/08/26/corruption-in-sysdependencies/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 5, 2009 at 10:31 am
Fab thanks Gail. Will check it out first thing tomorrow and advise.
Cheers, J.
November 5, 2009 at 11:00 am
Just for your info, these errors are usually (not always but usually) the result of direct updates done to the system tables on SQL 2000. Is this an upgraded database?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2009 at 7:47 am
I've run it against a backup and checkdb comes back with no errors now, as does a one-off integrity check. So thank you very much, you're a star. And it is apparently an upgraded 2000 database - although that would have happened over a year ago as it didn't happen while I've been here (to my knowledge!). SP3 threw the problems up.
Cheers, Jules
November 6, 2009 at 9:46 am
Excellent. Glad to hear it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply