Check the Nesting Level with @@nestlevel

@@nestlevel contains the nesting level of current execution with the user session, initially 0.

Each time a stored procedure or trigger calls another stored procedure or trigger, the nesting level is incremented. The nesting level is also incremented by one when a cached statement is created. If the maximum of 16 is exceeded, the transaction aborts.