Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

When you execute your procedure in your database then a very common error of MSSQL "Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)."
comes often.
Solution to this problem is when you execute your procedure then then use keyword 'Go' between final 'end' and exec procedure
Like
ALTER procedure [dbo].[test]
(
@a nvarchar(50),
@b nvarchar(50)
)
as
 declare @id int
 declare @Aid2 int 
 declare @counter int
    begin
                    select 1
      end
    go  

exec test 'starplus','starplus7'

This will solve your problem.......

 

Comments

Popular posts from this blog

DTS package conversion in SSIS to use in SQL 2012 and SQL 2016

Infinite Scroll in Asp.Net C# using Javascript without Third party Plugin

Add Custom Tags in Web config file in ASP .Net