Solved

Database owner and dbo user different

Posted on 2009-04-07
4
293 Views
Last Modified: 2013-11-05
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

0
Comment
Question by:carpi751
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 37

Accepted Solution

by:
Geert Gruwez earned 125 total points
ID: 24087108
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
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 24429218
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question