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

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


Date: Tue, 20 May 2003 17:33:05 -0400


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
> >
> >
>
>