How many Level Stored Procedure nesting possible in SQL Server

Last Reply 20 days ago By dharmendr

Posted 20 days ago

How many levels can a storeprocedure call within a storeprocedure?

Posted 20 days ago

Hi varun.p,

Stored procedures are nested when one stored procedure calls another. You can nest stored procedures up to 32 levels.

Refer below links for more details.

https://blog.sqlauthority.com/2008/09/15/sql-server-2008-interview-questions-and-answers-part-4/