Microsoft® SQL Server™ 2000 Unleashed, Second Edition

Creating Triggers

You can create and manage triggers in SQL Enterprise Manager. Right-click the table for which you want to manage triggers and choose All Tasks, Manage Triggers from the pop-up menu (see Figure 29.1).

Figure 29.1. Managing triggers for the current table in SQL Enterprise Manager.

Figure 29.2 displays the Trigger Properties window that is displayed after you select a table for which you want to manage a trigger. It provides a basic template from which you can code your trigger.

Figure 29.2. The Trigger Properties window.

TIP The ...