• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Database owner and dbo user different

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

  • 2
1 Solution
Geert GOracle 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
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.
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now