Re: SQL 2000 Problem with table ownership

From: Jen (jgisler_at_cadan.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 08:49:47 -0800

What is bol?

Jen
>-----Original Message-----
>Hi,
>
>Please refer bol for sp_changeobjectowner system procedure
>
>Thanks
>hari
>MCDBA
>
>"Jennifer Gisler" <jgisler@cadan.com> wrote in message
>news:26ff01c3fc85$47856400$a401280a@phx.gbl...
>> Hi,
>>
>> We have a SQL 2000 server, that we are working on and
when
>> we import, create, or anything with tables at all, no
>> matter what we try the only owner is dbo, even if we are
>> logged on as a different user with full owner and admin
>> rights.
>>
>> Is it possible to change the owner of a newly created
>> table to who created iut?
>>
>> Thanks,
>>
>> Jen :)
>
>
>.
>

Relevant Pages