Re: ERROR: [SQL-DMO] The name 'dbo' was not found in the users collection...

From: jrm (jhjim69_at_hotmail.com)
Date: 05/21/03


Date: Wed, 21 May 2003 08:09:46 -0400


Seems to have taken care of the problems.

Thanks Russell !

"jrm" <jhjim69@hotmail.com> wrote in message
news:ejwZwexHDHA.1772@TK2MSFTNGP10.phx.gbl...
> Thanks Russell, I'll run it and let you know what happens.
>
>
> "Russell Fields" <rlfields@sprynet.com> wrote in message
> news:OZi#09wHDHA.1960@TK2MSFTNGP11.phx.gbl...
> > jrm,
> >
> > I have seen this happen in the case where:
> >
> > Database Fred owned by 'sa' was backed up.
> >
> > User 'demigod' creates (or recreates) a database named Fred, then
restores
> > the backup that was owned by 'sa'.
> >
> > Now sysdatabases believes that the database is owned by 'demigod', but
> > Fred.dbo.sysusers believes that 'sa' created it.
> >
> > If this is your case, do the following:
> >
> > 1. Use sp_changedbowner to change to 'someotheruser'.
> > 2. Use sp_changedbowner again to change to 'sa'
> >
> > Russell Fields
> >
> > "jrm" <jhjim69@hotmail.com> wrote in message
> > news:uUrEaWuHDHA.3056@tk2msftngp13.phx.gbl...
> > > Hi,
> > > When selecting properties for sa under Logins I received the following
> > > error: [SQL-DMO] The name 'dbo' was not found in the users collection.
> If
> > > the name is a qualified name, use [] to separate various parts of the
> name
> > > and try again.
> > >
> > > The properties window will open but when I select the Database Access
> tab
> > > and scroll through all the databases for sa, the user column says dbo
> but
> > > the bottom half of the window, Permit in Database Role, db_owner is
NOT
> > > checked. When I attempt to check it and hit OK, I get the same error.
> > >
> > > Also, I can't add sa or dbo to the uses in the individual database, it
> > say's
> > > they are reserved.
> > >
> > > How to solve this problem. I need to make sure sa is the dbo in each
> > > database and get rid of all these error messages.
> > >
> > > TIA
> > >
> > > jrm
> > >
> > >
> >
> >
>
>