How many stored procedures can be nested?

How many stored procedures can be nested in SQL Server?

You can nest stored procedures up to 32 levels.

Can you nest stored procedures?

Nesting stored procedures means you have stored procedures that call stored procedures; each stored procedure may or may not have a transaction. To trap non-fatal errors in a called stored procedure, the called procedure must have some way to communicate back to the calling procedure that an error has occurred.

How many levels does Proc get nested?

Cataloged and in-stream procedures can invoke other procedures (up to 15 levels of nesting). In a procedure, an EXEC statement can invoke another procedure, which can contain an EXEC statement to invoke another procedure, and so on.

How do I make multiple stored procedures at once?

1 Answer1Right click the database in Management Studio and click on Task.2Click on Generate Scripts.3In the dialog that comes up, click next as you specify the right options.4Select the checkbox for "Stored Procedures"5Select All the required stored procedures.6Select option to generate script to a new window or file.