CODE EXAMPLE FOR SQL

recently updated stored procedure in sql server

select name,create_date,modify_date
from sys.procedures
order by modify_date desc