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

Exercise

Modifying a trigger's definition

A member of the Sales team has noticed that one of the triggers attached to the Discounts table is showing a message with the word "allowed" missing.

Instructions

100 XP
  • Modify the trigger definition and fix the typo without dropping and recreating the trigger.
  • Add the missing word to the PRINT statement.