June 28, 2002 at 6:54 am
how does one change the object owner of a user defined data type?
June 28, 2002 at 7:31 am
I would like to think there is a better way but the only way that I could find is to enable modifications to the system tables (Server Settings) and then on the database in question open up the systypes table and set the 'uid' column to 1 for the types that you are referring to.
I'll be interested to see if there is another way to do this.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 28, 2002 at 9:38 am
I thought sp_changeobjectowner would work, but it doesn't. Apparently a new datatype isn't an object, which makes some sense.
What symptoms are you seeing?
Steve Jones
October 13, 2006 at 9:55 am
I tried the Microsft solution from kb 327123 http://support.microsoft.com/kb/327123, didnt work. Had to make changes to systypes table to fix my issues.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply