Change ownership for User Defined Data Types

• alark

  Default port

  Points: 1402

  More actions

  May 10, 2006 at 2:52 pm

  #168923

  Hello,

   

  Does anybody know an easy way to change User Defined Data Types ownership to “dbo”, without dropping dependent objects?

   

  I know that there is a st. proc sp_changeobject owner, but it does not deal with this particular db objects. Is there a similar st.procedure or script that would do the same operation?

   

  Thank you

   

• HelloFOFO

  Old Hand

  Points: 349

  More actions

  May 10, 2006 at 9:27 pm

  #637146

  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

   

• alark

  Default port

  Points: 1402

  More actions

  May 11, 2006 at 8:43 am

  #637279

  Thank you Li Zhi-song for your help. It did work and solved my problem.