SELECT [name] ,
create_date ,
modify_date
FROM sys.all_objects
WHERE type_desc = N'SQL_STORED_PROCEDURE'
ORDER BY modify_date DESC
SELECT [name] ,
create_date ,
modify_date
FROM sys.all_objects
WHERE type_desc = N'SQL_STORED_PROCEDURE'
ORDER BY modify_date DESC