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 TAB.name AS TabloAdi,
       TRIG.name 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.

As you can see, all active triggers are listed.

Good luck to everyone in business and life.