use ur_DB
sp_configure 'Allow Update',1
Reconfigure WITH OVERRIDE
Update sysTypes
Set uid = user_id('sa') -- change "sa" with the new owner
Where Name = 'TestType'
--TestType is the name of the UDT
sp_configure 'Allow Update',0
Reconfigure WITH OVERRIDE