>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.