Server Triggers Editor (SQL Server)

Go Up to Microsoft SQL Server Object Editors

The Server Triggers Editor lets you enable or disable a logon-based or other event-based server trigger and modify the body of the generated CREATE TRIGGER statement.

To edit a server trigger:

1. Open an editor on the server trigger. For details, see Opening an Object Editor.
2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:

Tab	Settings and tasks
Properties	Select the Enabled check box to enable the server trigger or deselect it to disable the trigger. In addition to the name and creation date details, this tab also lets you view the Trigger Timing, Fire On Logon, and Encrypted property settings you chose when creating the trigger. For details on these properties, see Server Triggers (SQL Server) - Properties.
Definition	Lets you modify the CREATE TRIGGER statement.
Trigger Events	Lets you view the DDL events you selected to fire this trigger.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.