This particular issue I\u2019m about to describe should be pretty rare, but I\u2019m posting this here in the event that someone else encounters it and then finds this post and then hopefully applies the \u201cminimum required dose\u201d required to fix the problem instead of using more sweeping methods such as restoring from database backup…<\/span>\u00a0 <\/span><\/span><\/span><\/p>\n

I had a case today where the following message (with different ids) was appearing in DBCC CHECKDB output across several SQL Server 2005 databases that had original been hosted on SQL Server 2000 instances:<\/span><\/span><\/p>\n

Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=117575457<\/span><\/span>,referenced_minor_id=1) of row (class=0,object_id=1589580701<\/span><\/span>,column_id=0,referenced_major_id=117575457<\/span><\/span>,referenced_minor_id=1) in sys.sql_dependencies does not have a matching row (object_id=117575457<\/span><\/span>,column_id=1) in sys.columns.<\/span><\/span><\/p>\n

Given that sys.sql_dependencies is on the deprecation path (in favor of sys.sql_expression_dependencies) \u2013 one might decide to ignore the errors, but living with this kind of noise in DBCC CHECKDB might cause you to then not<\/em> pay attention in the event that more critical corruption errors occur.<\/span><\/span><\/p>\n

While there are a few invasive solutions for clearing out a metadata mismatch between sys.sql_dependencies and sys.columns, if you\u2019re encountering this issue between sys.sql_dependencies and sys.columns, first try EXEC sys.sp_refreshsqlmodule for the applicable object (for example \u2013 stored procedure) instead.\u00a0 <\/span>This system stored procedure will then update the metadata associated with the module and, as in today\u2019s case, clean up the mismatches and corruption warnings in DBCC CHECKDB.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

This particular issue I\u2019m about to describe should be pretty rare, but I\u2019m posting this here in the event that someone else encounters it and then finds this post and then hopefully applies the \u201cminimum required dose\u201d required to fix the problem instead of using more sweeping methods such as restoring from database backup…\u00a0 I […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-517","post","type-post","status-publish","format-standard","hentry","category-corruption"],"yoast_head":"\n