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

Материал из SQL эксперт
Перейти к: навигация, поиск

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

   <source lang="sql">

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></source>