Category: SQL 2008

Below is a method to list out DDL triggers which are created on your database SELECT * FROM sys.triggers WHERE parent_class=0 Please note that DDL triggers are not schema scoped and hence their information wont be available in system catalog…