1. Learn
    2. /
  2. Courses
    3. /
  3. Building and Optimizing Triggers in SQL Server
Connected

Exercise

Managing existing triggers

Fresh Fruit Delivery has asked you to act as the main administrator of their database.

A best practice when taking over an existing database is to get familiar with all the existing objects.

You'd like to start by looking at the existing triggers.

Instructions 1/3

undefined XP
  • 1
    • Get the name, object_id, and parent_class_desc for all the disabled triggers.
  • 2
    • Get the unmodified server-level triggers.
    • An unmodified trigger's create date is the same as the modify date.
  • 3
    • Use sys.triggers to extract information only about database-level triggers.