Changing ownership of an existing table? -- sql server clients

Keith Kratochvil
5/18/2004 1:37:52 PM

Yes. Read up on sp_changedbowner within Books Online (within the SQL =
Server program group).

--=20
Keith

[quoted text, click to view]

Keith Kratochvil
5/18/2004 2:44:46 PM

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

[quoted text, click to view]

wawork NO[at]SPAM hotmail.com
5/18/2004 6:30:17 PM

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

Dinesh T.K
5/19/2004 1:11:55 AM

Keith,

I assume you meant sp_changeobjectowner.

--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com

[quoted text, click to view]
Yes. Read up on sp_changedbowner within Books Online (within the SQL Server
program group).

--
Keith

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : Changing ownership of an existing table?