select
[name]
,create_date
,modify_date
FROM
sys.all_objects
where
type_desc = N'SQL_STORED_PROCEDURE'
and name = 'spSaveWork'
and modify_date >='2013-08-05 00:00:00'
select
[name]
,create_date
,modify_date
FROM
sys.all_objects
where
type_desc = N'SQL_STORED_PROCEDURE'
and name = 'spSaveWork'
and modify_date >='2013-08-05 00:00:00'