How to: Save a Trigger
You can save triggers to the database. When you save a new or updated trigger, it is added to the Tables folder.
Note
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
To save a trigger
From the File menu, click Save <trigger name>.
If you are updating an existing trigger, a message box prompts you to confirm the save action. Choose Yes.
A saved trigger appears in the Tables folder in Server Explorer under the table that it is associated with.