How to Recompile UDF
Posted on 2004-09-23
I sort of had this question in another thread but as it evolved from another question I thought I would repost this new one.
I have a number of connected inline and scaler UDF's which need to be recoompiled from time-to-time due to changes in underlying tables during development.
Does anyone know how to "manually" recompile these as I don't believe the sp_recompile/WITH RECOMPILE switches work for UDF's. My understanding, and according to the documention, is they only apply to Stored Procecedures.
I currently delete every UDF from the Db and then recreate them - a bit of a chore!
Thanks for any help.