Select Categories Below
Advertisement
Start Your Own Q&A Site
Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.
Status: Closed Points: 75 Time: 16:00 - Oct 20, 2006
dustPuppy
I need to change the owner of a table in my ms sql server 2000 database. How do I do that?
Categories:
Add Categories
When adding more than one category, separate them with commas.
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:
You're welcome however to comment or give additional information or if you wish, you have the ability to write a Tutorial in the Tutorial 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?
Enter your email address below and we will resend your login information to you.
Login Information Sent
Questions
how to export a database from ms sql server to access?
A server with this name already exists - sql server 2000 problem
How do I restore a database on sql server through the command prompt?
T-SQL: calling a stored procedure from within a stored procedure?
How do I connect to an ms access database with NHibernate?
You have 100 characters to use
Rank
Expert
Points
1.
10354
2.
6493
3.
5596
4.
4848
5.
3487
6.
2840
7.
2770
8.
2303
9.
1820
10.
917
Register today to share your knowledge with the community and be recognized and rewarded for your contributions.
Register Here
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
Language Options
English:
Español:
Sponsors
Questions and Answers Software