SQL Stored Procedure

SQL – Find Last Modified Stored Procedure or Function

In this post, we will look into some of the useful SQL Queries.
Following SQL Query will be really helpful to find last modified stored procedure or function.

SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = ‘P’ or type = ‘fn’ or type IN (‘FN’, ‘IF’, ‘TF’);

If you want to show last changed item at first use Order By with modified_date desc,

SELECT name,create_date,
modify_date
FROM    sys.tables
ORDER BY modify_date DESC;