Manage Triggers

Triggers can be conveniently managed right from the application itself with ApexSQL Audit via Outlook Bar, Audit Menu or Toolbar:

You can filter the triggers by table - the default is <All Tables> and also view the attributes of the selected trigger like Name, Owner and Create Date.

From the Manage Triggers form you can perform a variety of trigger related operations. You may , or even the checked triggers directly from the dialog. Deleting the triggers will be prevented by the confirmation dialog:

Disabling the triggers will un-mark the Enabled flag:

The trigger details pane shows all information regarding the currently chosen trigger:

Trigger Details

Detail	Description
Name	The trigger name.

Owner	The trigger owner.

Create Date	The date the trigger was created.

ANSI NULL	It is True if the ANSI_NULLS option on trigger creating was set to ON, otherwise is False.

Quoted Identifier	It is True if the QUOTED_IDENTIFIER option on trigger creating was set to ON, otherwise is False.

The checked triggers can be easily scripted (clicking ):

Buttons

Button	Description
	This will open the help file.

	This will enable the selected trigger(s).

	This will disable the selected trigger(s).

	This will script the selected trigger(s). The Script window will display.

	This will delete the selected trigger(s). A warning will be displayed before deleting.

	This will refresh the list of displayed triggers.

	This will close the dialog. If any operations were done, a Progress Info window will be displayed and the changes will be reflected in the Audit grid.

Context Menu

The Context Menu may be accessed by right-clicking in the grid.

Context Menu Index

Icon	Command	Action
	View DDL Script	Shows dialog with DDL/Script for this object.

	Script to File	This functionality allows you to write the trigger create statements to script for all of the selected triggers.

	Enable Checked Items	This will enable the selected items so they will no longer fire, even though they will still exist in the database.

	Disable Checked Items	This will disable the selected items so they will no longer fire, even though they will still exist in the database.

	Delete Checked Items	This will remove the checked items from the database.

	Select All	This will highlight all triggers.

	Check All	This will check all triggers.

	Un-Check All	This will un-check all selected triggers.

	Grid

	Sort Ascending	This will sort the tables ascending by the selected column.

	Sort Descending	This will sort the tables descending by the selected column.

	Collapse Groups	This will collapse the groups after the action of "Group by This Field" command.

	Expand Groups	This will expand the collapsed groups.

	Group by This Field	This will group the selected table(s) by the selected field.

	Hide/Show Group by Box	This will hide/show the box the table was grouped by.

	Hide/Show Filter Row	This will hide/show the filter row.

	Group by	This will open the Group By dialog box and you can choose up to four columns to group the table by.

	Sort by	This will open the Sort dialog box and you can choose up to for columns to sort the table by.

	Refresh	This will re-query the database to refresh the trigger grid to reflect any underlying changes.