>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'll check it out, thanks Sergey.

~~Bonnie



>
>>
>>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?