how to check the modified date of stored procedure in sql server

 for getting single stored procedure details use this


SELECT name, create_date, modify_dateFROM sys.objectsWHERE type = 'P' AND name = 'yourstoredprocedurename'


 for getting All stored procedure details use this 


SELECT name, create_date, modify_dateFROM sys.objectsWHERE type = 'P'
order by modify_date desc