DDL Event Groups for Use with Event Notifications

  • Article

The following diagram lists the DDL event groups that can be used to run an event notification, and also the Transact-SQL statements they cover. Note the inclusive nature of the event groups, as indicated by the tree structure of the diagrams. For example, an event notification that specifies FOR DDL_TABLE_EVENTS covers the CREATE TABLE, ALTER TABLE and DROP TABLE Transact-SQL statements, while an event notification that specifies FOR DDL_TABLE_VIEW_EVENTS covers all Transact-SQL statements under DDL_TABLE_EVENTS, DDL_VIEW_EVENTS, DDL_INDEX_EVENTS, and DDL_STATISTICS_EVENTS.

Note

Certain system stored procedures that perform DDL-like operations can also fire event notifications. Test your event notifications to determine their responses to system stored procedures that are run. For example, the CREATE TYPE statement and sp_addtype stored procedure will both fire an event notification that is created on a CREATE_TYPE event. However, the sp_rename stored procedure does not fire any event notifications.

DDL event groups for use with event notifications

See Also

Concepts

Designing Event Notifications

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

14 April 2006
New content:
  • Added a note that recommends testing event notifications to determine their responses to stored procedure that are executed.