select [name] ,create_date ,modify_date FROM sys.all_objects where type_desc = N'SQL_STORED_PROCEDURE' --and name = 'spName' and modify_date >='2015-08-05 00:00:00' ORDER BY modify_date DESC
select [name] ,create_date ,modify_date FROM sys.all_objects where type_desc = N'SQL_STORED_PROCEDURE' --and name = 'spName' and modify_date >='2015-08-05 00:00:00' ORDER BY modify_date DESC