You are here:  
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

Comments

There are currently no comments, be the first to post one.

Post Comment

Name (required)

Email (required)

Website

Enter the code shown above:

Search Blog
TKC Blog Latest Articles
Blog Archive
 
Home | About Us | Benefits | TKC Blog | Contact Us