Re-enabling a disabled trigger
You helped the company update the Orders
table by disabling the PreventOrdersUpdate
trigger.
Now they want the trigger to be active again to ensure no unwanted modifications are made to the table.
This exercise is part of the course
Building and Optimizing Triggers in SQL Server
Exercise instructions
- Re-enable the disabled
PreventOrdersUpdate
trigger attached to theOrders
table.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Resume the trigger execution
___ ___ ___
ON ___;