Hi Vernon,

Kalen Delaney wrote an exellent article "User-Defined Data Types" http://www.windowsitpro.com/SQLServer/Article/ArticleID/37427/37427.html.

She provides a stored procedure that shows all user defined datatypes.

Please let me know it this answers all your questions.

Thanks

Regard

Yakov