[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

How to change owner on a User Defined Data Type

Posted on 2003-11-24
3
Medium Priority
?
971 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

649 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