Finding the DML Triggers created or modified during a date range in SQL Server

In an earlier article we have seen how to find the stored procedures created or modified in a given date range from an SQL Server database. Now we will see about finding the DML Triggers which are modified or created during a given date range. You can get this list using sys.triggers. sys.trigger is catalog view for sys.objects. By using the created_date and modify_date columns in this catalog view, you can get the triggers which are created or modified during a certain date. Her is the script:

SELECT
    name,
    type,
    create_date,
    modify_date
FROM
   sys.triggers
WHERE
    create_date between '2020-05-01' and '2020-06-30'
    or modify_date between '2020-05-01' and '2020-06-30'

Reference

• More about sys.triggers at Microsoft Docs.