Hello all,

Let's say I have multiple stored procedures that have the following statement:

SELECT * FROM vAview WHERE ...

The statement is to return all columns in the view listed.

Now, today I change the view definition to have more columns. Since I have multiple stored procedures, do I need to manually script each of these and alter the stored procedure by executing these individually or can I do some kind of global recompile? Or is either one of these not necessary?

TIA

Bob