NestLevel in SQL Server Stored Procedures

@@NESTLEVEL
Returns the nesting level of the current stored procedure execution

Each time a stored procedure calls another stored procedure, the nesting level is incremented. When the maximum of 32 is exceeded, the transaction is terminated.