Why You Shouldn't Dynamically Create/Alter/Delete Triggers

When you change triggers on a SQL Server table, you need an exclusive lock on a table. If you can't get it, you can cause a blocking firestorm.