Change Ownership of Tables

I would like to change the ownership of the few tables from a user to dbo.
What is the best way to do this ?
Never done this before. What possible impact could this have ?
--
RKHi RK
Please read about sp_changeobjectowner in the Books Online
Any code that references object owners will have to be changed
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"RK73" <RK73@.discussions.microsoft.com> wrote in message
news:1EF21A6E-4B7A-4A6E-BE50-D4F75FC5FAFC@.microsoft.com...
>I would like to change the ownership of the few tables from a user to dbo.
> What is the best way to do this ?
> Never done this before. What possible impact could this have ?
> --
> RK|||Even tho this is stated in BOL. sp_changeobjectowner This procedure removes
all existing permissions from the object. You will need to reapply any
permissions you want to keep after running sp_changeobjectowner.
For this reason, it is recommended that you script out existing permissions
before running sp_changeobjectowner. Once ownership of the object has been
changed, you may use the script to reapply permissions. You will need to
modify the object owner in the permissions script before running.
Sometimes overlooked
usually not twice.
"RK73" wrote:

> I would like to change the ownership of the few tables from a user to dbo.
> What is the best way to do this ?
> Never done this before. What possible impact could this have ?
> --
> RK