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 Advertisements

Read More →