>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
See also
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23420252.html
If it's not broken, fix it until it is.
My Blog