Weil ich auch das immer wieder vergesse:

use MyDB
 
declare @proc varchar(50)
 
declare procs cursor for select SPECIFIC_NAME from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='PROCEDURE' and SPECIFIC_NAME like '%whatever%'
open procs
fetch next from procs into @proc
while @@FETCH_STATUS = 0
begin
   print @proc
   exec sp_recompile @proc
   fetch next from procs into @proc
end
close procs
deallocate procs