tkaragiris posted on February 15, 2010 15:06

The query below will find any stored procedures or tables modified within the last seven days:
SELECT name AS [Stored Procedures]
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7
SELECT name AS Tables
FROM sys.objects
WHERE type = 'U'
AND DATEDIFF(D,modify_date, GETDATE()) < 7