Online Documentation for SQL Administrator for SQL Server

Options


Use the Options tab to specify additional options of the trigger being created.

 

Trigger Editor - Options

 

 

Options

 

!CheckBox ANSI Nulls

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.

 

!CheckBox Quoted identifier

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.

 

!CheckBox 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.

 

!CheckBox Encrypted

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.

 

Execute as

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

 

Use the Fired first on and Fired last on groups of options to specify the AFTER triggers that are fired first or last. The AFTER triggers that are fired between the first and last triggers are executed in undefined order.