what the ... I have been doing lately on sql server ...

for first time no sources ; ) Really !!!

use db
go 

select  o.name  , 
(SELECT [definition] AS [text()] FROM sys.all_sql_modules where sys.all_sql_modules.object_id=a.object_id FOR XML PATH(''), TYPE) AS Statement_Text
, a.object_id, o.modify_date  from sys.all_sql_modules  a left join sys.objects  o on a.object_id=o.object_id order by 4 desc

--select * from sys.objects

-- Make sure the "Results to Grid" is selected