?
Solved

How to change owner on a User Defined Data Type

Posted on 2003-11-24
3
Medium Priority
?
976 Views
Last Modified: 2013-12-03
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 -
0
Comment
Question by:rmayer
3 Comments
 
LVL 15

Expert Comment

by:namasi_navaretnam
ID: 9812149
User defined datatypes are not assciated with an owner. So that sp_changeobjectowner cannot be used.



0
 

Author Comment

by:rmayer
ID: 9812357
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
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 9813381
Question closed and points refunded

PashaMod
CS Moderator
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question