Questions | Solutions | Experts

Select Categories Below

.net [

]

asp.net [

]

browsers [

]

C# [

]

CSS [

]

Databases [

]

email [

]

Errors [

]

HTML [

]

information tec... [

]

Question

Status: Closed Points: 75 Time: 16:00 - Oct 20, 2006

dustPuppy

change owner of objects in ms sql server

I need to change the owner of a table in my ms sql server 2000 database.
How do I do that?

Categories:

SQL Server 2000 Databases

Answer Discussion

Answer Summaries

Q&A System for Websites and Corporate Collaboration

Generates significant organic traffic for websites
Saves companies money, resources, and time

dustPuppy

Date:: Oct 20, 2006

Time:: 16:04

I found out that I have to run this stored procedure in the SQL Query Analyzer:
EXEC sp_changeobjectowner 'CurrentOwner.TableName', 'newOwner'

Question Answered

This question has been closed, and points have been rewarded to the following experts:

dustPuppy:

You're welcome however to comment or give additional information or if you wish, you have the ability to write an Answer Summary for the Summary Area.

Answer this Question

New User

Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:

Forgot Your Password?

No summaries have been submitted yet. Want to be the first?