How many Level Stored Procedure nesting possible in SQL Server

Last Reply 18 days ago By dharmendr

Posted 18 days ago

How many levels can a storeprocedure call within a storeprocedure?

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