Just Learned - SQL Server - sp_changeobjectowner can be used to change table owner

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

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]

Published under: SQL Server Tips · · · ·

RKA

91 · 2% · 598

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


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


	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

282 · 0% · 150

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