We have Windows 2003 running on our servers and we upgraded our databases from SQL2000 to SQL2005 two weeks ago. We migrated all of our maintenance plans at that time. All seem to work but one: The integrity check. We deleted the migrated plan and created one from scratch using SQL2005...it still failed. I have tried researching the error and had no luck...here is the text from the error message:
Executing the query "DBCC CHECKDB WITH NO_INFOMSGS" failed with the following error:
"Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=30262
4121,refer
enced_mino
r_id=1)
of row (class=0,object_id=1732957
27,column_
id=0,refer
enced_majo
r_id=30262
4121,refer
enced_mino
r_id=1)
in sys.sql_dependencies does not have a matching row (object_id=302624121,colum
n_id=1) in sys.columns.
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=30262
4121,refer
enced_mino
r_id=1)
of row (class=0,object_id=2929121
15,column_
id=0,refer
enced_majo
r_id=30262
4121,refer
enced_mino
r_id=1)
in sys.sql_dependencies does not have a matching row (object_id=302624121,colum
n_id=1) in sys.columns.
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=30262
4121,refer
enced_mino
r_id=1)
of row (class=0,object_id=3089121
72,column_
id=0,refer
enced_majo
r_id=30262
4121,refer
enced_mino
r_id=1)
in sys.sql_dependencies does not have a matching row (object_id=302624121,colum
n_id=1) in sys.columns.
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=30262
4121,refer
enced_mino
r_id=1)
of row (class=0,object_id=1778821
399,column
_id=0,refe
renced_maj
or_id=3026
24121,refe
renced_min
or_id=1)
in sys.sql_dependencies does not have a matching row (object_id=302624121,colum
n_id=1) in sys.columns.
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=78615
3896,refer
enced_mino
r_id=1)
of row (class=0,object_id=1732957
27,column_
id=0,refer
enced_majo
r_id=78615
3896,refer
enced_mino
r_id=1)
in sys.sql_dependencies does not have a matching row (object_id=786153896,colum
n_id=1) in sys.columns.
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=10525
82838,refe
renced_min
or_id=4)
of row (class=0,object_id=1732957
27,column_
id=0,refer
enced_majo
r_id=10525
82838,refe
renced_min
or_id=4)
in sys.sql_dependencies does not have a matching row (object_id=1052582838,colu
mn_id=4) in sys.columns.
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=13162
51794,refe
renced_min
or_id=12)
of row (class=0,object_id=1732957
27,column_
id=0,refer
enced_majo
r_id=13162
51794,refe
renced_min
or_id=12)
in sys.sql_dependencies does not have a matching row (object_id=1316251794,colu
mn_id=12) in sys.columns.
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=13162
51794,refe
renced_min
or_id=66)
of row (class=0,object_id=1732957
27,column_
id=0,refer
enced_majo
r_id=13162
51794,refe
renced_min
or_id=66)
in sys.sql_dependencies does not have a matching row (object_id=1316251794,colu
mn_id=66) in sys.columns.
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=15882
52763,refe
renced_min
or_id=2)
of row (class=0,object_id=1732957
27,column_
id=0,refer
enced_majo
r_id=15882
52763,refe
renced_min
or_id=2)
in sys.sql_dependencies does not have a matching row (object_id=1588252763,colu
mn_id=2) in sys.columns.
CHECKDB found 0 allocation errors and 9 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 9 consistency errors in database 'Comfort'.".
Possible failure reasons:
Problems with the query,
"ResultSet" property not set correctly,
parameters not set correctly,
or connection not established correctly.