One often has a need to check the last modified date or the created date of a stored procedure in SQL. So, below is an SQL script that allows you to view the stored procedure name, created date and last modified date of the stored procedure.
GO SELECT name, create_date, modify_date
WHERE type = 'P' AND name = 'StoredProcedureName'
Hope this helps 🙂