SQL Server/T-SQL Tutorial/System Tables Views/sys.server triggers

Viewing DDL Trigger Metadata by joining sys.server_triggers and sys.server_trigger_events

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>