Hi

I hate UDT's, they are hopessly deficient, why?

a) i cant easily change the "real" type for the udf once bound to N tables

b) they can be a nightmare to manage when moving data between dbms versions in terms of compatibility and debugging truncation issues etc.

c) can cause future issues, namely, a business rule change may result in the name used for the UDT to become confusing and not reflect its actual purpose (although this is a standards issue more than anything).

To be truely helpful, you must be able to change the type and for the change to dynamically cascade through the dbms. If it doesnt happen automatically, then I see no benefit from them.

Try harder Microsoft ! 🙂

Cheers

Chris.