Online Documentation for SQL Manager for SQL server
Use the Trigger tab of Trigger Editor to create/edit a DML trigger and specify its properties.
Enter a name for the new trigger, or modify the name of the trigger being edited.
Table or view
Select the trigger behavior type:
This selection specifies that the trigger is fired only when all operations specified in the triggering SQL statement have executed successfully.
This selection specifies that the trigger is executed instead of the triggering SQL statement.
Specify the data modification statements that activate the trigger when it is tried against this table or view: Insert, Update or Delete. At least one option must be specified.
Enables/disables the trigger immediately after it is created. Enabling a trigger causes it to fire when any Transact-SQL statements on which it was originally programmed are executed. A disabled trigger still exists as an object in the current database, but does not fire.
Not for replication
This option allows you to specify that the trigger should not be executed when a replication agent modifies the table that is involved in the trigger.
You can check this option to encrypt the text of the CREATE TRIGGER statement if you want to ensure that other users cannot view the trigger definition.
This option specifies ISO compliant behavior of the Equals (=) and Not Equal To (<>) comparison operators when they are used with null values. When this option is switched on, a SELECT statement that uses WHERE column_name = NULL returns zero rows even if there are null values in column_name. A SELECT statement that uses WHERE column_name <> NULL returns zero rows even if there are nonnull values in column_name.
This option causes SQL Server to follow the ISO rules regarding quotation mark delimiting identifiers and literal strings. When this option is switched on, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. When it is switched off, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers.
Specify the security context under which the trigger is to be executed: Caller, Owner, Current user or User (select which user account should be used to validate permissions on the 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.
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 DML statements cause the trigger actions to be performed.
The trigger actions take effect when the DML operation is performed.