Last modified

SELECT name Name, type_desc [Type], modify_date Modified
FROM sys.objects
WHERE type IN ('P', 'U', 'V', 'FN')
AND DATEDIFF(D, modify_date, GETDATE()) < 14
ORDER BY type_desc, modify_date DESC