DennisPost (8/22/2014)
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.
Good solution. I read this thread yesterday, but couldn't come up with any ideas so didn't commetn.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question