- Open SQL Server Enterprise Manager and highlight the SQL instance the database is attached to
- Right-click, select Properties and select the Server Settings tab
- Mark the Allow triggers to be fired which fire other triggers (nested triggers) checkbox and click OK
- Restart the SQL Server Instance
Connect and collaborate with fellow Blackbaud users.