SQL 2000 Problem with table ownership

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

Date: Thu, 26 Feb 2004 08:26:25 -0800

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