I need to alter a table (add new columns) that is referenced by over one hundred stored procedures. I believe the query trees and execution plans for these SPs will need to be re-resolved and re-compiled, respectivley. I'm concerned about query growth, but do not want the pain of having to drop and recreate all these SPs

Any advice??

Thanks in advance.