Nel

Nel

  • NA
  • 716
  • 1.1m

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

May 18 2012 7:13 AM
I have this SQL procedure:

ALTER procedure [dbo].[prikVP]
(
@brdok int
)
as
select Vidpod.idpod, Vidpod.vp from Vidpod, blagajna
where Vidpod.idpod=blagajna.vp and blagajna.brdok=@brdok

exec prikVP
@brdok=1

and I get an error: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

Can anybody help me please?

Thanks


Answers (4)