SELECT * FROM sys.objects
WHERE TYPE = 'U' AND DATEDIFF(D,modify_date, GETDATE()) < 30
SELECT * FROM sys.objects
WHERE TYPE = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < 30
SELECT * FROM sys.objects
WHERE TYPE = 'F' AND DATEDIFF(D,modify_date, GETDATE()) < 30
SELECT * FROM sys.objects
WHERE TYPE = 'V' AND DATEDIFF(D,modify_date, GETDATE()) < 30