Can table ownership be changed?

When I create tables in SQL I can specify dbo as the owner using the
syntax below but when using the upsize wizard in Access 2000 I own
everything. Is there a way that the system administrator can change
ownership after the fact?

CREATE TABLE dbo.mytable (c1 int not null)

Thank You,
Randy K
wawork@.hotmail.comOn 18 May 2004 12:16:39 -0700, Randy wrote:

>When I create tables in SQL I can specify dbo as the owner using the
>syntax below but when using the upsize wizard in Access 2000 I own
>everything. Is there a way that the system administrator can change
>ownership after the fact?
>CREATE TABLE dbo.mytable (c1 int not null)
>
>Thank You,
> Randy K
>wawork@.hotmail.com

Hi Randy,

sp_changeobjectowner [ @.objname = ] 'object' , [ @.newowner = ] 'owner'

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)