Hi Bonnie,

There's a way but it's quite involved. See mskb #327123 HOW TO: Change the Owner of a User-Defined Data Type That Is in Use in SQL Server 2000.

>
>I'm using SQL 2005. There are a couple of sp's that handle adding and removing User-Defined DataTypes:
>
>sp_addtype
>sp_droptype
>
>I want some way of updating the types. Does anyone know if that's possible? Here's an example.
>
>Say I have a udt_streetnumber defined as CHAR(6). I already have several tables defined using this udt. Now I realize that 6 isn't big enough and I want to expand it to be CHAR(10). Can I do this?