Creating a report on existing triggers

Taking on the responsibility of administrating the database for the Fresh Fruit Delivery company also means keeping an eye on existing triggers.

The best approach is to have a report that can be run regularly and outputs details of the existing triggers.

This will ensure you have a good overview of the triggers and give you access to some interesting information.

XP

Start creating the triggers report by gathering information about existing database triggers from the sys.triggers table.