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