Changing ownership of an existing table?

Can the ownership of an existing SQL table be changed from the a user
to DBO? How? Sorry but I'm a novice.
Randy K
wawork@.dfw.wa.gov
Yes. Read up on sp_changedbowner within Books Online (within the SQL =
Server program group).
--=20
Keith
"Randy K" <wawork@.hotmail.com> wrote in message =
news:40aa55ca.8925156@.msnews.microsoft.com...
> Can the ownership of an existing SQL table be changed from the a user
> to DBO? How? Sorry but I'm a novice.
>=20
> Randy K
> wawork@.dfw.wa.gov
|||Keith,
I assume you meant sp_changeobjectowner.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:O25ILdQPEHA.3452@.TK2MSFTNGP10.phx.gbl...
Yes. Read up on sp_changedbowner within Books Online (within the SQL Server
program group).
Keith
"Randy K" <wawork@.hotmail.com> wrote in message
news:40aa55ca.8925156@.msnews.microsoft.com...
> Can the ownership of an existing SQL table be changed from the a user
> to DBO? How? Sorry but I'm a novice.
> Randy K
> wawork@.dfw.wa.gov
|||Yeah, read up on that one sp_changeobjectowner. sp_changeobjectowner =
will work a bit better than sp_changedbowner My fingers typed one =
thing while my brain was thinking something else.
Dinesh, Thanks for the correction!
--=20
Keith
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message =
news:uYnLtARPEHA.3944@.tk2msftngp13.phx.gbl...
> Keith,
>=20
> I assume you meant sp_changeobjectowner.
>=20
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
>=20
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:O25ILdQPEHA.3452@.TK2MSFTNGP10.phx.gbl...
> Yes. Read up on sp_changedbowner within Books Online (within the SQL =
Server[vbcol=seagreen]
> program group).
>=20
> --=20
> Keith
>=20
>=20
> "Randy K" <wawork@.hotmail.com> wrote in message
> news:40aa55ca.8925156@.msnews.microsoft.com...
user
>=20
>