Finding the stored procedures created or modified in a given date range in SQL Server

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' 

Related Articles

• Finding a stored procedure by searching with it’s partial name in SQL Server.

Reference

• Read More about sys.procdures at Microsoft Docs.