DDL Event Groups for Use with Event Notifications
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.
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.
Help and Information
14 April 2006