TKC Blog
15

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

Posted in: SQL Server
Search Blog