How to change owner on a User Defined Data Type

I thought sp_changeobjectowner would work since it worked on my Default objects, but it doesn't work on User Defined Data Types.  I'm using SQL Server 2000.

- Robert -
rmayerAsked:
Who is Participating?
 
PashaModCommented:
Question closed and points refunded

PashaMod
CS Moderator
0
 
namasi_navaretnamCommented:
User defined datatypes are not assciated with an owner. So that sp_changeobjectowner cannot be used.



0
 
rmayerAuthor Commented:
Apparent that's not true.  In Enterprise Manager they do show up with an Owner column displayed.  In any case, I did find this article that offers the solution, albeit not as simple a solution as I was hoping for:  http://support.microsoft.com/default.aspx?scid=kb;en-us;327123

- Robert -
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.