Audits for Indexed Views
You can run the following DDDAudit queries for the indexed views to resolve any inconsistency in the database.
-
IVIEWS-1
-
IVIEWS-2
-
IVIEWS-3
-
IVIEWS-4
See the Indexed View Queries [Microsoft SQL Server] section for detailed audit queries.