>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

BTW, found again this blog http://c2.com/cgi/wiki?StoredProceduresAreEvil :) I disagree, of course.