Altering an indexed view will drop all indexes on it without warning, even if nothing is changed.
This will prevent accidental alters.
Script is divided into 4 parts, included testing and cleanup scripts.
2015-09-01 (first published: 2015-08-13)
Dynamically generate trigger DDL and write to individual SQL files.
2013-12-02 (first published: 2013-11-18)
DDL trigger will add a user to a newly created database and assign db_owner role. It can be modified for what role is required.
2015-03-12 (first published: 2013-08-22)
One of the most amazing features to an old SQL Server 4.2 guy was the addition of DDL triggers to...
2012-08-07 (first published: 2012-07-31)