title: How can I quickly identify most recently modified stored procedures in SQL Server
body: <p>I need to manually migrate modified stored procedures from a DEV SQL Server 2005 database instance to a TEST instance.  Except for the changes I'm migrating, the databases have the same schemas.  How can I quickly identify which stored procedures have been modified in the DEV database for migration to the TEST instance?</p>
  <p>I assume I can write a query against some of the system tables to view database objects of type stored procedure, sorting by some sort of last modified or compiled data, but I'm not sure.  Maybe there is some sort of free utility someone can point me to.</p>