General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Environment versions
SQL Server:
SQL Server 2005
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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only