Home > Miscellaneous > How to get all disable-enabled trigger from database

How to get all disable-enabled trigger from database

Sachin Mahajan Miscellaneous, MS SQL Server, MySQL, SQL Azure 0

just we need to fire a query

1
2
3
4
5
6
7
SELECT  
       TAB.name as Table_Name
     , TRIG.name as Trigger_Name
     , TRIG.is_disabled  --or objectproperty(object_id('TriggerName'), 'ExecIsTriggerDisabled')
FROM [sys].[triggers] as TRIG
inner join sys.tables as TAB
on TRIG.parent_id = TAB.object_id

 


Avatar photo
Sachin Mahajan

Related articles

WordPress website migration using plugins

There are many ways available to migrate the WordPress website from one

Difference between DML Triggers and DDL Triggers in MS SQL Server

A trigger is an event based stored procedure that automatically executes when an event

Method Overriding in Java – PART-3

Rules of method overriding in JavaArgument list: The argument list of overriding

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">