microsoft.public.sqlserver.server

Author

cascading triggers

Pascal Michael Haddad

2002-08-14, 6:23 am

Hello
Is there a way to turn off the cascading triggers in one statement?
thx
Pascal

Darren Brinksneader

2002-08-14, 6:23 am

You can turn off recursive triggers at the database level with:

sp_dboption 'recursive triggers', false

You can turn off nested triggers at the server level with:

sp_configure 'nested triggers', 0

--
Darren Brinksneader
MCDBA, MCSE, CCDA, MCT, CTT+, CCA, CNE

"Pascal Michael Haddad" <phaddad@sabaip.com> wrote in message
news:e8u6qa4QCHA.1576@tkmsftngp12...
> Hello
> Is there a way to turn off the cascading triggers in one statement?
> thx
> Pascal
>
>

Sponsored Links