Solved

DBO Ownership change MSSQL Enterprise Manager

Posted on 2007-04-11
3
822 Views
Last Modified: 2010-08-05
How do you change the ownership of a table in a database to dbo using the SQL Server Enterprise Manager?
0
Comment
Question by:asaworker
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
Otana earned 500 total points
Comment Utility
I don't think you can. You'll have to run this stored procedure from Query Analyzer:
sp_changeobjectowner 'objectname','newowner'
0
 

Author Comment

by:asaworker
Comment Utility
so my query would be sp_changeobjectowner 'course_category','dbo'
0
 

Author Comment

by:asaworker
Comment Utility
EXEC('sp_changeobjectowner @objname = ''myname.course_category'', @newowner = dbo')

That fixed it! Thanks for your help!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

762 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now