---

Search posts under SQL Server:

---

Enable trigger in SQL Server

How to enable trigger in SQL Server?

To enable trigger that was disabled, we use ENABLE TRIGGER statement.

ENABLE TRIGGER InsertAccounts
ON PersonalDetails

Above lines of code will enable InsertAccounts table created on PersonalDetails table.

Executing above SQL statement will enable the query and inserting a record into PersonalDetails table will start firing InsertAccounts table as well.