SQL Server Tips

Getting Started with Web applications development with servlets and JSP - Part 5: Filters

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.


	Just Learned

Upload Image

Close it

Select File

Learned something today? Share it, or learn from what others have learned today


	Like

Invite Friends

Tips · Submit A Tip · Members (427) · Preferences · Feedback · Most Liked · Most Learned · Most Discussed · Silver Rated

SQL Server - sp_changeobjectowner can be used to change table owner

Dec 7 2011 10:14PM by RKA

Inorder to change the owner of the table to dbo, we can do like this.

 
sp_changeobjectowner '<tablename>', 'dbo'
GO

Read More.. [0 clicks]

RKA

106 · 2% · 430

Liked

Knew

Learned

Incorrect

Interesting

Forgotten

Move


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it
This post should be moved to a more appropriate category


	Submit

1 Comments

This stored procedure only works with the objects available in Microsoft SQL Server 2000. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER SCHEMA or ALTER AUTHORIZATION instead

commented on Dec 8 2011 5:45AM .

harishs

255 · 1% · 117

Your Comment

Sign Up or Login to post a comment.

"SQL Server - sp_changeobjectowner can be used to change table owner" rated 5 out of 5 by 10 readers