instead of using sysobjects which is not recommended anymore use sys.procedures
select name,create_date,modify_date
from sys.procedures
order by modify_date desc
you can do the where clause yourself but this will list it in order of modification date descending