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

Difference between Block and inline level elements

Nearly all HTML elements are either block or inline elements. The characteristics of block elements include:Always

Download free bug tracking template

A bug tracking or defect tracking is to keep the track of

Importance of Data protection policy in Website

1. What is data protection policy? The Data Protection policy covers data held

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="">