Re: Cannot change the database owner

From: Geoff N. Hiten (sqlcraftsman_at_gmail.com)
Date: 10/24/05 

Date: Mon, 24 Oct 2005 16:32:42 -0400

SA is already mapped to a user in the database. Delete that user and retry
the command. 

-- 
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Rich" <Rich@discussions.microsoft.com> wrote in message 
news:AC045038-6DB4-4854-A927-32F03F984D38@microsoft.com...
> Hello Group,
>
> I have restored a database to a server and want to change the owner from 
> me
> to the SA.  I have tried to use " Exec sp_changedbowner 'sa' " but get 
> this
> error:
>
> Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 46
> The proposed new database owner is already a user in the database.
>
> I have done this at least hundred times without a problem, what is this
> error saying about the USER?  I am trying to chang the owner...
>
> Rich

Relevant Pages

  • RE: Using Access with concurrent users
    ... > See way below, at end of this stuff, for getting a user's network login ... > If you are optimizing the performance of an Access database, ... > to start is with the Performance Analyzer. ... > that connects to a Microsoft SQL Server database and is used to create ...
    (microsoft.public.access.setupconfig)
  • RE: Using Access with concurrent users
    ... See way below, at end of this stuff, for getting a user's network login ... If you are optimizing the performance of an Access database, ... The Performance Analyzer can also make some proposed changes for you if you ... Microsoft SQL Server database and is used to create client/server ...
    (microsoft.public.access.setupconfig)
  • RE: SMS_INVENTORY_DATA_LOADER Error
    ... Microsoft SQL Server reported SQL message 547, ... statement conflicted with TABLE REFERENCE constraint 'DataItemContext_1_FK'. ... The conflict occurred in database 'SMS_100', ... Rolling back policy transaction due to error. ...
    (microsoft.public.sms.inventory)
  • Re: 2008 Express Edition missing Data drivers?
    ... I think I found the posts I was looking for: ... 2000 instance but the only drivers available are Microsoft Access DataBase ... file, Microsoft Sql Server Compact 3.5, and Microsoft SQL Server Database ... connections in a manner I am familiar with. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: SMS_INVENTORY_DATA_LOADER Error
    ... Microsoft SQL Server reported SQL message 547, ... statement conflicted with TABLE REFERENCE constraint 'DataItemContext_1_FK'. ... The conflict occurred in database 'SMS_100', ... Rolling back policy transaction due to error. ...
    (microsoft.public.sms.inventory)