Updated on Kisan Patel
This tutorial will show you how to enable trigger in SQL Server?
To enable trigger that was disabled, we use ENABLE TRIGGER statement.
ENABLE TRIGGER UPDATETrigger1 ON Region
Above lines of code will enable UPDATETrigger1 table created on Region table. Executing above SQL statement will enable the query and inserting a record into Region table will start firing UPDATETrigger1 table as well.