**SQL-DMO 21776**

Hi
I want to change the sa password ,but following error appearred( the picture
enclosed),
"Error 21776; SQL-DMO the name 'dbo' was not found in the user collection
,if the name is a qualified name,use [] to seperate various parts of the
name, and try again."
I'd be grateful if anybody can help me.DMO doesn't like NULL database owners. You may get this message when one or
more database owners are invalid due to a restore, attach or because the
database owner's Windows account was removed.
You can identify problem databases with:
SELECT name
FROM master..sysdatabases
WHERE SUSER_SNAME(sid) IS NULL
You can then use sp_changedbowner to specify a valid database owner login.
See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"maryam rezvani" <rezvani@.parskhazar.net> wrote in message
news:%23Yx%236ohKFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hi
> I want to change the sa password ,but following error appearred( the
> picture
> enclosed),
> "Error 21776; SQL-DMO the name 'dbo' was not found in the user collection
> ,if the name is a qualified name,use [] to seperate various parts of the
> name, and try again."
> I'd be grateful if anybody can help me.
>
>
>