In an earlier article we have seen couple of methods of listing all the Stored Procedures in an SQL Server database. Now we will see about finding the stored procedures which are modified or created during a given date range. You can get the list from the sys.procedures object catalog view by using the created_date and modify_date columns. This will be helpful for auditing purpose. Here is the script.
SELECT name, type, create_date, modify_date FROM sys.procedures WHERE create_date between '2020-05-01' and '2020-06-30' or modify_date between '2020-05-01' and '2020-06-30'
- Read More about sys.procdures at Microsoft Docs.