>>>Hi All, I have a udf which I use as a default value in several tables in my database - if I try to modify the udf I receive the error cannot modify ... etc... as it is being referenced by mytable... - do I have to modify all the tables and remove the reference before I can make the change ? I hope not !!!
>>
>>Don't use user defined type as default value as this is getting deprecated. I had a problem recently when I wanted to change all text/ntext types to varchar(max)/nvarchar(max) and found this problem.
>>
>>I was able to create such a script though, so if you will need it, let me know.
>
>I don't use user defined types I use the return value of a udf as a default value for certain fields.

That's good then, I think. Except for the problem of modifying the function.