List All Stored Procedure Modified in Last N Days

By Chaitanya Talasila on October 11, 2011

Hi All,

We have sys.objects catalog view that is used from the sql server 2005

Below script is used to find the stored Procedures that are modified with in week

SELECT name

FROM sys.objects

WHERE type = ‘P’

AND DATEDIFF(D,modify_date, GETDATE()) < N

Where N is Number of days

Same can be done using the views sys.system_objects, sys.all_objects

You can place any object like table, views etc except dml triggers and these are found in the another system catalog view sys.triggers.

We have these many types of objects that are referened in this view

Regards,

Chaitanya,

To Send Mail : mssqlbuzz

Posted in: Uncategorized

SQL BLOGGING