How to refresh user-defined functions
sql, sql-server
Solution
You should look at sp_refreshsqlmodule.
Problem
Possible Duplicate: SQL Server UDF refresh The system stored procedure `sp_refreshview` can be used to validate and recompile views in SQL Server. How can I do the same for scalar functions and table functions?