How to change database owner from SQL 6.5?

i'm performing sql server migration from 6.5 to server 2000,so i change the
database owner to dbo .i wanna change all the object owner to dbo
"acd" <acd@.msn.com> ¼¶¼g©ó¶l¥ó·s»D:u$kU9FVfGHA.2456@.TK2MSFTNGP04.phx.gbl...
> i'm performing sql server migration from 6.5 to server 2000,so i change
> the database owner to dbo .
>|||DBO cannot be the database owner, as the database owner is a login name, and
dbo is a user name within the database. The login name which owns the
database ALWAYS maps to the user name dbo, so there is no way to change the
owners name to anything else, and no reason you would ever have to change
the name TO dbo.
For you second question, SQL 6.5 does not provide the option to change owner
names. It is possible to directly update the system tables to change object
ownership, but it is not supported and not recommended unless you have a LOT
of experience working with the system metadata. The support approach is to
drop the objects and then recreate them with the desired owner.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"acd" <acd@.msn.com> wrote in message
news:em6jZKVfGHA.1264@.TK2MSFTNGP05.phx.gbl...
>i wanna change all the object owner to dbo
> "acd" <acd@.msn.com>
> ¼¶¼g©ó¶l¥ó·s»D:u$kU9FVfGHA.2456@.TK2MSFTNGP04.phx.gbl...
>> i'm performing sql server migration from 6.5 to server 2000,so i change
>> the database owner to dbo .
>>
>|||thanks for your reply...
i having a problem for testing database mirgration..
i facing the problem was..when i restore the the database to another sql
server 6.5 and performed database upgrade to 7.0. Since the object own by
different users..so some of the table can not move to 7.0
do u have any idea to help me that problem?
"Kalen Delaney" <replies@.public_newsgroups.com> ¼¶¼g©ó¶l¥ó·s»D:%23Q%23iujVfGHA.4276@.TK2MSFTNGP03.phx.gbl...
> DBO cannot be the database owner, as the database owner is a login name,
> and dbo is a user name within the database. The login name which owns the
> database ALWAYS maps to the user name dbo, so there is no way to change
> the owners name to anything else, and no reason you would ever have to
> change the name TO dbo.
> For you second question, SQL 6.5 does not provide the option to change
> owner names. It is possible to directly update the system tables to change
> object ownership, but it is not supported and not recommended unless you
> have a LOT of experience working with the system metadata. The support
> approach is to drop the objects and then recreate them with the desired
> owner.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "acd" <acd@.msn.com> wrote in message
> news:em6jZKVfGHA.1264@.TK2MSFTNGP05.phx.gbl...
>>i wanna change all the object owner to dbo
>> "acd" <acd@.msn.com> ¼¶¼g©ó¶l¥ó·s»D:u$kU9FVfGHA.2456@.TK2MSFTNGP04.phx.gbl...
>> i'm performing sql server migration from 6.5 to server 2000,so i change
>> the database owner to dbo .
>>
>>
>