There's nothing built into the engine to do what you want but you can still automate the drop and create of the function. SP_HELPTEXT will return the source of the function. Use it to get the source, then drop and recreate the function.

-Mike

>Hi,
>
> I have over 50 UDFs in a big cascade, I use them in a custom data transfere(see exemple below), but the probleme is that every time a structure change happen (new columns) we need to recreate these UDF (no code modification).
>
>Is there a way to force a schema refresh of all UDF in SQL Server 2000 SP3a?
>
>
>exemple :
>
>CREATE FUNCTION [Dbo].[Ana_UdfV_SyncGetQuotation] (@psDirGuID uniqueidentifier)
>RETURNS TABLE
>AS
>RETURN (select A.* from Quotation A
> inner join Ana_UdfV_SyncGetCompany (@psDirGuID) B
> on A.ClientGuID = B.GuID)
>
>
>CREATE FUNCTION [Dbo].[Ana_UdfV_SyncGetScenario] (@psDirGuID uniqueidentifier)
>RETURNS TABLE
>AS
>RETURN (select A.* from Scenario A
> inner join Ana_UdfV_SyncGetQuotation (@psDirGuID) B
> on A.TrmanGuID = B.GuID)
>
>
>
>Alain
>Analystik Inc.