How many levels a Nested Trigger / Recursive Trigger can go in SQL Server 2008 !

milani_lucie
milani_lucie used Ask the Experts™
on
Hi,

Can you please let me know:

How many levels a Nested Trigger / Recursive Trigger can go in SQL Server 2008 ? I know it is 32 levels in SQL Server 2000.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
ITS 32

Commented:
Yup. 32. And you need to make sure that you've allowed the option for it to be any!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial