Listing Active Triggers in SQL Server
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.