Re: SQL 2000 Problem with table ownership
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 02/26/04
- Next message: Hari Prasad: "Re: How to fix SQL Server 2000 after machine name & domain change ?"
- Previous message: Adam Machanic: "Re: Surrogate Key"
- In reply to: Jennifer Gisler: "SQL 2000 Problem with table ownership"
- Next in thread: Jen: "Re: SQL 2000 Problem with table ownership"
- Reply: Jen: "Re: SQL 2000 Problem with table ownership"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 22:20:06 +0530
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 :)
- Next message: Hari Prasad: "Re: How to fix SQL Server 2000 after machine name & domain change ?"
- Previous message: Adam Machanic: "Re: Surrogate Key"
- In reply to: Jennifer Gisler: "SQL 2000 Problem with table ownership"
- Next in thread: Jen: "Re: SQL 2000 Problem with table ownership"
- Reply: Jen: "Re: SQL 2000 Problem with table ownership"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
