Solved

How do I change a single table from dbo ownership?

Posted on 2008-06-11
5
409 Views
Last Modified: 2012-08-13
I'm trying to change ownership of a single table from dbo to one of the managers. I have complete sa rights. The solution that I saw earlier wouldn't work. Please Help.
0
Comment
Question by:DanteKingsley
  • 2
  • 2
5 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 250 total points
ID: 21764430
0
 
LVL 19

Assisted Solution

by:Melih SARICA
Melih SARICA earned 250 total points
ID: 21764520
try this

EXEC sp_changeobjectowner 'authors', 'Corporate\GeorgeW'
auhours is the table namei george is the new owner

Melih SARICA
0
 

Author Comment

by:DanteKingsley
ID: 21764629
Hello non zero, I've tried that and everything else and here's what I get...
0
 
LVL 19

Expert Comment

by:Melih SARICA
ID: 21764681
u get any error when u execute the command ?

and what is the version of ur sql server ?
0
 

Author Closing Comment

by:DanteKingsley
ID: 31466371
I apologize for the delay in my response as I was in an auto accident.

Thank you !!!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

829 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