Solved

Database owner and dbo user different

Posted on 2009-04-07
4
291 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
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Divide by zero error encountered. 2 43
configure service broker on all databases 2 88
Delete from table 6 47
Query 14 57
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

837 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