Other drawbacks of the ADT:
* When you need to "change" the type the effort is more than with native
* When dealing with temporary tables you have to have them in model by the time you restart SQL Server or use a startup procedure to add them to tempdb. This is harder than native datatypes
* replication has issues with some of these types
* Because it hides implemetation details it forces you to find out the definition.
* Like posted above not many providers deal with this successfully
* Linked servers can be trashed because of this
Because of all the above (and possibly more that I may be missing) I would vote for the use of ADT as a BAD parctice!
Cheers!
* Noel