Getting Error msg 217
Maximum storerd procedure , function, trigger, or viewnesting level exceeded (limit 32).
unable to resolve here is what i am doing.
while @i <=5
begin
@param =some calculation based on @i
exec sp_name @param1 ,@parm2 output
set @i= @+1;
end;
i tried
SP_CONFIGURE 'Nested_triggers',0
go
reconfigure with override
go
how to resolve this.