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' 
Finding the stored procedures created or modified during a given date range in SQL Server

Related Articles

Reference


Leave your thoughts...

This site uses Akismet to reduce spam. Learn how your comment data is processed.