Online Documentation for SQL Manager for SQL server
Creating/editing DDL trigger
Use the DDL Trigger tab of DDL Trigger Editor to create/edit a database-scoped DDL trigger and specify its properties.
Enter a name for the new DDL trigger, or modify the name of the DDL trigger being edited.
Enables/disables the trigger immediately after it is created. A disabled trigger still exists as an object in the current database, but does not fire.
If this option is selected, the text of the CREATE TRIGGER statement is encrypted. Using this option prevents the trigger from being published as part of SQL Server replication.
Specify the security context under which the trigger is to be executed: Caller, Self or User (select which user account should be used to validate permissions on any database objects that are referenced by the trigger).
Select the trigger code source: it can be a direct set of SQL statements or an external procedure call from a .NET assembly or DLL.
This area lists the DDL events as groups. The trigger will fire after execution of any data definition language event selected in this list. Set the corresponding flag next to an event or event group name.
SQL statements or assembly method
This area allows you to set the trigger conditions and actions. Trigger conditions specify additional criteria that determine whether the tried DDL statements cause the trigger actions to be performed.
The trigger actions take effect when the DDL operation is performed.