How many Level Stored Procedure nesting possible in SQL Server

Last Reply 11 months ago By dharmendr

Posted 11 months ago

How many levels can a storeprocedure call within a storeprocedure?

Posted 11 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/