Online Documentation for SQL Manager for SQL server

Setting DDL trigger properties


Use the DDL Trigger tab of DDL Trigger Editor to configure/view server-scoped DDL trigger properties.

 

Name

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

 

DDL Trigger Editor (server) - 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 server, but does not fire.

 

CheckBox Encrypted

If this option is selected, the text of the CREATE TRIGGER statement is encrypted.

 

Execute as

Specify the security context under which the trigger is to be executed: RadioButton Caller, RadioButton Self or RadioButton Login (select which login account should be used to validate permissions on any server 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.

 

Event type

This group is available for SQL Server 2008. Specifies trigger type:

RadioButton Server level

RadioButton Logon

 

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.