declare @funcname nvarchar(100)=N'';

declare curFunc cursor for

select

 [name]

 --,create_date

 --,modify_date

FROM

 sys.all_objects

where

 type_desc LIKE '%FUNCTION%'

 and substring([name],1,3) not in ('dm_','fn_')

 and modify_date >='2013-07-11 00:00:00'

order by

 modify_date desc;

open curFunc;

fetch next from curFunc into @funcname;

while @@FETCH_STATUS = 0

begin

 print(N'IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE [NAME]=N''' + @funcname +''' AND [TYPE]=''FN'')')

 PRINT(N'DROP FUNCTION ' + @funcname);

 print N'GO';

 exec ('sp_helptext ' + @funcname);

 print N'GO';

 fetch next from curFunc into @funcname;

end

close curFunc;

deallocate curFunc;