Changing a table-valued function that a stored procedure calls is not recognized?
- by Peter
Hey all
I have a stored procedure sp that calls a table-valued function tvf. Sometimes I modify the tvf but when subsequently executing sp, the output from sp is the same as before the modification. It seems like it is cached or compiled or something. If I make some dummy change to the sp, then I get the right output of the sp.
Is there some way,…