Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

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>