maximum number of nests allowed in a trigger anyone?

[neroe]

any of you guys know what is the maximum number of nests allowed in a trigger?

thanks in advance

 

[JayKusch]

If we are talking "how many nested triggers are allowed w/in one trigger" the answer would be 32.

Thanks

J. Kusch

 

[JayKusch]

By the way, you can determine the current "nest-level" by accessing the global variable @@nestlevel. The nest level of the trigger is held in @@nestlevel.

Thanks

J. Kusch

 

[neroe]

Thankyou very much,it never fails to impress me the speed and quality of responce at this site. By the way you may well have secured me a £25k job.
Cheers,
Neroe.

 

[JayKusch]

Excellent! The world always needs another quality DBA.

Thanks

J. Kusch

 

[SemperFiDownUnda]

/me looks at JayKusch :/