How many Level Stored Procedure nesting possible in SQL Server

Last Reply 9 months ago By dharmendr

Posted 9 months ago

How many levels can a storeprocedure call within a storeprocedure?

Posted 9 months 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/