Re: ERROR: [SQL-DMO] The name 'dbo' was not found in the users collection...
From: jrm (jhjim69_at_hotmail.com)
Date: Tue, 20 May 2003 17:33:05 -0400
Thanks Russell, I'll run it and let you know what happens.
"Russell Fields" <firstname.lastname@example.org> wrote in message
> 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" <email@example.com> wrote in message
> > 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.
> > the name is a qualified name, use  to separate various parts of the
> > and try again.
> > The properties window will open but when I select the Database Access
> > and scroll through all the databases for sa, the user column says dbo
> > 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
> > 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