this iteration of the steps will recompile( or more correctly mark for recompilation ) all stored procedures in all the databases.
You could easliy add an AND and and further filtering to only work with just the objects you are needing to recompile.
I have had a few issues where I renamed and database and the execution plans were pointing to the old database and it was trying to use and offline database. So I created this. Once I ran this there were no more issues and all the procs execution plans were fresh.
Thanks for looking.