Often for my deployments I need a script that recreates all stored procs and then grants the public role to have access to it. I posted a script that someone else had developed a long time ago but.... it sucked.... ya. so here is the simple new one:

select    'grant execute on '+[name]+ ' to public'
from    sysobjects
where    xtype='P'
or        xtype='FN'