SQL Query to get modified procedures

SQL Query

You can use a simple query in sql server 2005 to get the modified procedures from a particular date. You just need to specify the date in the query.

Try it out !!!

SELECT name , modify_date FROM sys.objects
WHERE type = ‘P’ AND modify_date >= ‘2011-11-24’ order by name

In the same way, you can retreive the modified tables also

SELECT name , modify_date FROM sys.objects
WHERE type = ‘U’ AND modify_date >= ‘2011-11-24’ order by name