Re: Change dbo

I understand that Administrator is nothing special in SQL, it is just a
convenient user to setup. Administrator is already setup. I assume that is
why I cannot Alter Authorization to Administrator and get the following
message:

Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the
database.

I assume I would have to remove Administrator, then change the
Authorization?

Thanks to you, it is working now - I can play some more with it in the
future.


.

Relevant Pages

  • Re: Installing XP Pro Tablet Edition and restricting users?
    ... You can configure Automatic Updates by using Group Policy ... "Administrator" is an account. ... a member of the "Administrators Group", ... | Interestingly during setup I entered a password and also setup the one & ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Domain users members of local administrator
    ... My setup allows the technically proficient to run as a secured, ... they simply do not need to run as administrator. ... accounts out of Administrators, setup Windows update to auto-update, ...
    (microsoft.public.security)
  • Re: Change dbo
    ... Administrator is already setup. ... that is why I cannot Alter Authorization to Administrator and get the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: Searching for Tools to Assist in Administrative Keyword Search
    ... Setup a replica of your domain controller on an isolated network, ... Exchange 2003 in that network, ... Administrator to open all mailboxes. ...
    (microsoft.public.exchange.admin)
  • Re: Newbie question about setting up XP - coming from win98se background
    ... >(accounts with the .xxxx trail in name) but there may be others. ... Management/Local Users, it's showing the "hidden" Administrator acct, ... the Guest acct, the Niteowl, Kalehli, and Maurine accts. ... It seems like I named it during setup... ...
    (microsoft.public.windowsxp.basics)