how to finf ddl triggers through query

Question

question

jhunu asked Dec 7, '11

how to finf ddl triggers through query

sql-server-2012

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-12-07T12:05:57Z

salum answered Dec 7, '11

You can use sys.server_triggers to get list of triggers on server scope. http://www.java-forums.org/database/

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ commented · Dec 07, 2011 at 02:59 PM

The link doesn't seem to pertain to DDL triggers. Is there a DDL trigger answer on that site I missed?

0 ·

Answer 2 · 2011-12-07T22:57:51Z

Pavel Pawlowski answered Dec 7, '11

The system view `sys.triggers` contains information about all triggers in a database. DDL triggers have a `parent_class = 0` as are database scoped so to retrieve all database level DDL trigers, you can issue SELECT * FROM sys.triggers where parent_class = 0 The system view `sys.server_triggers` contains all Server scped DDL triggers. SELECT * FROM sys.server_triggers

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question