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:
SELECT
OBJECTPROPERTY(OBJECT_ID('YourTrigger'),'ExecIsTriggerDisabled')
which returns 1 if disabled, 0 if enabled.

-Sue

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

Quote:

>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