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>