Sometimes as a DBA we must check if a trigger is enabled. To do so we can use sys.triggers. The exact query is:
select * from sys.triggers where is_disabled =0
By selecting all the data from sys.triggers you can see all triggers and if the column “is_disable” has a value of 1, that means that the trigger is disabled. To find more about sys.triggers check this link.
Like this:
Like Loading...
Related
Published by
isalom
I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish).
I'm a Systems Engineer graduated from The Hague University (http://www.thehagueuniversity.com/). I have been working in IT for over 15 years. Since November 2014 I started www.cenlinea.com a webportal were the focus is to make learning more fun. At Cenlinea we are currently promoting PLAYDIOM a new methodology to learn English. While currently working part-time time at Cenlinea, I am also working as Senior Princiapal Consultant at www.ccgroep.com which helps me to keep up to date with Microsoft SQL Server, which I consider to be one of my favorite things in life as it has changed my life in many ways.
I hope you enjoy my blog and if you want to send a question, just drop me a mail at ignacio.salom@cenlinea.com or ignacio@ccgroep.com
View all posts by isalom
IgnacioSalom.com 