Listing Active Triggers in SQL Server

Hello everyone,

In this section, I will talk about how to list active triggers in SQL Server.

In SQL Server, in some cases, it may be necessary to list active triggers for the database.

Using the code below, you can list your active triggers for your database.

SELECT AS TabloAdi, AS TriggerAdi,
       TRIG.is_disabled AS Pasiflik
FROM [sys].[triggers] AS TRIG
    INNER JOIN sys.tables AS TAB
        ON TRIG.parent_id = TAB.object_id;

When you run the query, you will see a result like the one below.

Listing Active Triggers in SQL Server

As you can see, all active triggers are listed.

Good luck to everyone in business and life.


Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!