EXEC sp_MSforeachDB 'DBCC CHECKDB (?) WITH ALL_ERRORMSGS,EXTENDED_LOGICAL_CHECKS, DATA_PURITY'
I am currently having an issue withconsistency error message when running the error massages:
EXEC sp_MSforeachDB 'DBCC CHECKDB (?) WITHALL_ERRORMSGS,EXTENDED_LOGICAL_CHECKS, DATA_PURITY'
To resolve the issue, a repair on the database was performed then the followingDBCC script was run:
DBCCCHECKDB (databasename) and is completed successfully.
The issue now is, thefollowing day when the data integrity job was run, the issue reoccurred:
Error message:
The spatial index,XML index or indexed view 'sys.extended_index_0000000 (object ID ) does not containall rows that the view definition produces.
CHECKDB found 0allocation errors and 4 consistency errors in database 'databasename'.
repair_rebuild is theminimum repair level for the errors found by DBCC CHECKDB (databasename).
Thank you in advance