Get Stored Procedure Last Modified Date or Updated Date in SQL Server

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

 

 

If we want to get specific procedure modified date we need to write the query like this 

 

 

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