[code sql]SELECT *
FROM sys.sql_modules sm
inner join sys.all_objects ao
on sm.object_id = ao.object_id
order by modify_date desc
[/code]
FROM sys.sql_modules sm
inner join sys.all_objects ao
on sm.object_id = ao.object_id
order by modify_date desc
[/code]