That is my question. Do I need to alter (or re-define) the SP in this situation when the view columns have change and SELECT * is used in a SP. I believe it is necessary but I am not sure. I wanted to confirm with people in the know.


>Why should it need to alter the SP? If I undestood correctly, you're already selecting all the view fields with SELECT * in all your SP. If you've specified the fields name in the SP (SELECT Field1, Field2, etc.), then you would need to modify them to add the new field, but with SELECT *, there's no need to modify the SP.
>
>>I guess my question is when you recompile a SP using sp_recompile, does it also inherently perform an ALTER on the procedure as well?