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.

 

Name

Enter a name for the new DDL trigger, or modify the name of the DDL trigger being edited.

 

DDL Trigger Editor - Editing DDL trigger definition

 

 

CheckBox Enabled

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.

 

CheckBox Encrypted

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.

 

Execute as

Specify the security context under which the trigger is to be executed: RadioButton Caller, RadioButton Self or RadioButton User (select which user account should be used to validate permissions on any database objects that are referenced by the trigger).

 

Code Source

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.

 

Events

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.