Yesterday I came across a situation where after an underlying view was altered to add a new column(view is a simple select statement) the stored procedure using that view failed giving some conversion error. the stored procedure does not use * but uses explicit
even after recompiling the SP with sp_recompile the issue was not solved.
we then dropped stored procedure and recreated it (using same script). And it ran sucessfully.
Any specific reasons for this behaviour. I have an understanding that stored procedure should have got recompiled automatically.
View Complete Post