Setting Nested Triggers

In SQL Server nested triggers must be allowed. For more information on nested triggers, search for “nested triggers” in the SQL Server Books Online.

1. In the SQL Server Management Studio, right-click the server and click Properties. The Server Properties dialog box appears.
2. Under Select a page, click Advanced. The Advanced page appears.
3. Under Miscellaneous, ensure Allow Triggers to Fire Others is set to True.