Triggers are user-defined functions that are executed automatically after a CREATE, UPDATE, or DELETE statement on tables or views is executed. In SQL Server 2005, triggers can also be fired on database level.
If a trigger is defined for a particular table, view, or—with SQL Server 2005—database, the SQL statement(s) in the trigger definition are executed automatically before, after, or instead of the statement that activates the trigger.
You can use an existing trigger as a basis for creating a new trigger definition or delete a trigger from the database. The context menu in the Online Browser provides several options in this respect (see Generating SQL Statements).