Customers
MS SQL Maestro online Help
Prev  |
Return to chapter overview | Next  |
Specifying trigger properties
Comment
This field contains a comment to the table trigger.
Execute As
Specifies the security context under which the trigger is executed.
Type (After, Instead of)
Specifies the trigger type.
After: the trigger is fired only when all operations specified in the triggering SQL statement have executed successfully.
Instead Of: the trigger is executed instead of the triggering SQL statement, therefore, overriding the actions of the triggering statements.
Events
One of Insert, Update, or Delete; this specifies the event that will fire the trigger.
Enabled
If checked, the trigger is enabled.
Not For Replication
When checked, it is indicated that the trigger should not be executed when a replication agent modifies the table that is involved in the trigger.
| Prev |
Return to chapter overview | Next |
