Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Database owner and dbo user different

Posted on 2009-04-07
4
Medium Priority
?
299 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
  • 2
2 Comments
 
LVL 38

Accepted Solution

by:
Geert Gruwez earned 375 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 38

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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
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…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

580 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