Viewing DDL Trigger Metadata by joining sys.server_triggers and sys.server_trigger_events : sys.server_triggers « System Tables Views « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Tables Views
3. sys.server_triggers

4>
5> SELECT name, s.type_desc SQL_or_CLR,
6> is_disabled, e.type_desc FiringEvents
7> FROM sys.server_triggers s
8> INNER JOIN sys.server_trigger_events e ON
9> s.object_id = e.object_id
10> GO
name
         SQL_or_CLR                                                   is_disabled FiringEvents

------------------------------------------------------------------------------------------------------------------------
-------- ------------------------------------------------------------ ----------- --------------------------------------
----------------------
trg_RestrictNewLogins
         SQL_TRIGGER                                                            0 CREATE_LOGIN

srv_trg_RestrictNewLogins
         SQL_TRIGGER                                                            0 CREATE_LOGIN

1>