How to refresh the definition of a T-SQL user-defined function after a dependent object is redefined?

Short, easy answer is No You have to redefine the RETURN TABLE statement in Tabular UDF GetFoo() whenever the definition of v_Foo changes But there is a way to get around it (translated as not practical) Create a DDL trigger on ALTER_VIEW event Then use a dynamic SQL to create the GetFoo().

Short, easy answer is No. You have to redefine the RETURN TABLE statement in Tabular UDF, GetFoo() whenever the definition of v_Foo changes. But there is a way to get around it (translated as not practical).

Create a DDL trigger on ALTER_VIEW event. Then use a dynamic SQL to create the GetFoo().

It would be nice to see the definition of the function. All you've said is it is using SELECT *. Can you be more specific?

You also forgot to tell us what version of SQL Server you are using. If >= 2005, have you looked at sp_refreshsqlmodule? technet.microsoft.com/en-us/library/bb32... technet.microsoft.com/en-us/library/bb32... Curious what your reasons are for insisting on SELECT *.

Lots of discussion about it here, but the cons still outweigh the pros by a large margin, IMHO: sqlblog.com/blogs/aaron%5Fbertrand/archi....

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.