I know if you make a change to a table you need to use sp_Refreshview on your views that use the table. I have a stored Proc that does this for each view.
My question is do you need to do something similar to stored procs that use the table?
If you do, is there a stored proc that would go through each of your procedures and recompile or what ever you need to do to each procedure?
Thanks in advance for any help.