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
TechieSpice 