Getting Information About DDL Triggers

The catalog views and system stored procedures listed in this section can be used to get information about DDL Triggers.

Database-Scoped DDL Triggers

To get information about database-scoped triggers

To get information about database events that fire triggers

To view the definition of a database-scoped trigger

To get information about CLR database-scoped triggers

Server-Scoped DDL Triggers

To get information about server-scoped triggers

To get information about server events that fire triggers

To view the definition of a server-scoped trigger

To get information about CLR server-scoped triggers

See Also

Other Resources

DDL Triggers

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

12 December 2006

Changed content:
  • To view the definition of a server-scoped trigger, use the sys.server_sql_modules catalog view.