How to check the created date and last modified date of a stored procedure in SQL ?

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.

USE DatabaseName; 
GO SELECT name, create_date, modify_date 
FROM sys.objects 
WHERE type = 'P' AND name = 'StoredProcedureName'
GO

Hope this helps :)