How to get Stored Procedure's Last Modified Date or Updated Date in SQL Server

Introduction: 

In this article I will explain how to get stored procedure’s last modified date in SQL server 2008.

Following query is used to get stored procedures last modified date:

SELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P'

Result: 

Get specific procedure modified date:

SELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P' AND name like 'DeleteEmployee'

Result: