Get startedGet started for free

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.

This exercise is part of the course

Building and Optimizing Triggers in SQL Server

View Course

Exercise instructions

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

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Fix the typo in the trigger message
___ TRIGGER PreventDiscountsDelete
ON ___
INSTEAD OF DELETE
AS
	PRINT 'You are not ___ to remove data from the Discounts table.';
Edit and Run Code