Home Forums SQL Server 2008 SQL Server 2008 Administration Prevent ALTER VIEW on indexed view RE: Prevent ALTER VIEW on indexed view
DennisPost
SSCrazy
Points: 2691
More actions
August 22, 2014 at 3:25 am
#1740112
Resolved.
Daily job saves all indexed views into a table.
DDL trigger checks if the view to be alter is in the IndexedView table.
If so, raise error & rollback.
To alter the view, the view must be deleted from the IndexedView table.