How many Level Stored Procedure nesting possible in SQL Server

Last Reply one year ago By dharmendr

Posted one year ago

How many levels can a storeprocedure call within a storeprocedure?

You are viewing reply posted by: dharmendr one year ago.
Posted one year 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/