Cacher is the code snippet organizer for pro developers

SELECT	name as 'Recently Modified', 
		modify_date as 'Date', 
		DATEDIFF(D, modify_date, GETDATE()) Delta
FROM sys.objects
WHERE	type = 'P' 
		--AND DeltaQ.Delta < 45
ORDER BY modify_date DESC

SELECT	name as 'Recently Created', 
		create_date as 'Date', 
		DATEDIFF(D, create_date, GETDATE()) as Delta
FROM sys.objects
WHERE	type = 'P' 
		--AND DATEDIFF(D, create_date, GETDATE()) < 5
ORDER BY create_date DESC