Possible duplicate:Upgrading SQL Server UDF
The system stored procedure sp_refreshviewcan be used to validate and recompile views in SQL Server.
sp_refreshview
How can I do the same for scalar functions and table functions?
You should look at sp_refreshsqlmodule .