Triggers, Triggers and more Triggers 
Author Message
 Triggers, Triggers and more Triggers
How do check whether a trigger is enable or disable?

Tue, 16 Nov 2004 23:36:31 GMT
 Triggers, Triggers and more Triggers

You can use something like:
which returns 1 if disabled, 0 if enabled.


On Fri, 31 May 2002 08:36:31 -0700, "Jimmy Mac"


>How do check whether a trigger is enable or disable?

Wed, 17 Nov 2004 00:24:49 GMT
 [ 2 post ] 

 Relevant Pages 

1. To trigger or not to trigger

2. Why aren't my Triggers triggering?

3. Disable Trigger within a Trigger

4. Update Trigger and ChildID Insert Trigger

5. SQL 2000 Multiple Triggers/Trigger Order

6. trigger for db audit purposes - newbie to the world of triggers

7. Default value and Trigger question ( implement before trigger)

8. Trigger Problem (Delete Trigger)

9. Trigger Newbie... Help with Trigger

10. Disable a trigger from within another trigger or stored procedure

11. Trigger-Happy Triggers

12. Oracle Triggers->SqlServer Triggers URGENT!!!

Powered by phpBB® Forum Software