how to change default 'dbo' login info

Hi all,
sql server 2000.
I took over a database which has the system default
user: 'dbo' login as one of the consultants' name who left
the company already.
How can I change the login back to normal which should be
under 'sa'?
I tried to delete it and recreate 'dbo' for this database,
the system won't let me. I try to modify anything
on 'dbo', the system won't let me.
Help...
JJHi,
Does that user owns any object, if yes use the sp_changeobjectowner
procedure to change the owner to dbo. After that
use sp_changedbowner procedure to change the dbo to sa.
Thanks
Hari
MCDBA
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:103901c3dfc1$e3c226e0$a101280a@.phx.gbl...
> Hi all,
> sql server 2000.
> I took over a database which has the system default
> user: 'dbo' login as one of the consultants' name who left
> the company already.
> How can I change the login back to normal which should be
> under 'sa'?
> I tried to delete it and recreate 'dbo' for this database,
> the system won't let me. I try to modify anything
> on 'dbo', the system won't let me.
> Help...
> JJ|||JJ
dbo is a user name, not a login name. Every db must have that user, so you
can't delete it. It is mapped to a LOGIN name in the master database and you
can change the mapping quite easily using the stored procedure
sp_changedbowner. There is no need to do anything with objects owned by
'dbo' user. Objects now owned by the user dbo will still be owned by dbo
after you change its mapping to point to the 'sa' login.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:103901c3dfc1$e3c226e0$a101280a@.phx.gbl...
> Hi all,
> sql server 2000.
> I took over a database which has the system default
> user: 'dbo' login as one of the consultants' name who left
> the company already.
> How can I change the login back to normal which should be
> under 'sa'?
> I tried to delete it and recreate 'dbo' for this database,
> the system won't let me. I try to modify anything
> on 'dbo', the system won't let me.
> Help...
> JJ