SQL Server: Script to find Status of all Database Trigger

In this post, I am sharing one of the important TSQL Script to find the different status like Enable, Disable of a SQL Server Database Trigger.

Database Trigger is a very important object because it is playing the main role in the background and manipulate defined DDL and DML commands.

As a Database Administrator, this is our responsibility to find out the different status of all running Trigger of a SQL Server Database.

Below is a script to find the different status of all Triggers.

Anvesh Patel

Leave a Reply

4 Comments on "SQL Server: Script to find Status of all Database Trigger"

Notify of
avatar
Sort by:   newest | oldest | most voted
Marie
Guest

I am no longer positive the place you are getting your info,
however good topic. I must spend some time learning much
more or working out more. Thank you for great
information I was in search of this information for my mission.

henny
Guest

Hi, just wanted to say, I loved this blog post. It was funny.

Keep on posting!

trackback

nice collection Mr. Anvesh…..

trackback

thanks, it is working for me…

wpDiscuz