Learn about the nested triggers option. See how to use it to set the number of levels of AFTER triggers that can cascade in SQL Server.