Sunday, February 19, 2012

how to know if trigger is disabled?

Is there a functoin or property that you can look at to tell if a trigger
has been disabled? Something in the schema?
Like:
Print IsTriggerDisabled(tblCustomers.MyTrigger)
KeithHi
For more information please read this article and that will answer your
question:
http://sqljunkies.com/Article/F5783...39BCC3096B.scuk
thanks and regards
Chandra
"Keith G Hicks" wrote:

> Is there a functoin or property that you can look at to tell if a trigger
> has been disabled? Something in the schema?
> Like:
> Print IsTriggerDisabled(tblCustomers.MyTrigger)
> Keith
>
>|||Cool. Thank you. :)
- keith

No comments:

Post a Comment