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'
- More about sys.triggers at Microsoft Docs.