Sorry mromm, I don't mean to pick, but quite honestly, If you cannot enforce data domain integrity reliably in your SQL Server, what makes you think you can enforce the usage of a UDT. From my perspective, its just as easy to enforce the fact that a money field is created as a money field as it is to enforce that a money field is created as a UDT. I don't see that as a benefit.

It could actually be viewed as a deficit if the dba's get to relying on it rather than researching their field definitions against the data library.

Edited by - scorpion_66 on 12/16/2002 9:21:05 PM