Nov 19, 2015
sys.foreign_keys does not have matching row in sys.indexes
sys.foreign_keys does not have matching row in sys.indexes
Running DBCC CHECKDB you are getting following error message: Check Catalog Msg 3853, State 1: Attribute (referenced_object_id=194099732,key_index_id=7) of row (object_id=2040565179) in sys.foreign_keys does not have a matching row (object_id=194099732,index_id=7) in sys.indexes This error means, that Unique key constraint (index_id 7) in the primary table (object_id 194099732) is missing, which…
View On WordPress