Database owner and dbo user different

Hi,
I have a SQL2005 database with a database owner different from the dbo user.
sp_helpdb returns "sa" as owner
and on the database, sp_helpuser 'dbo' returns a different login.

Could you explain me how is it possible ?

Thanks a lot.
sp_helpdb 'mydatabase'
 
name db_size owner ....
------ ---------- ---------
mydatabase   200 MB    sa ...
 
mydatabase..sp_helpuser 'dbo
UserName GroupName LoginName  ....
------------ --------------- --------------
dbo           db_owner    foo

Open in new window

carpi751Asked:
Who is Participating?
 
Geert GConnect With a Mentor Oracle dbaCommented:
a restore from a backup from a other computer and database can make this happen
the userid doesn't match

you'll need to reset the owner of the db
0
 
Geert GOracle dbaCommented:
Giving a C grade without any comments,
and neither any comments on what is not clear.

Not accepted !
Read the recommendations for giving grades in the help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.