Express 2005 - Database Diagram Error

Installed adventure works..and when creating a database diagram giving
a message says that it does not have valid owner.
The adventure works database is in SQL 2005 compatibility mode.
Perhaps the database owner doesn't exist? Try below:
SELECT * FROM sys.databases AS db
WHERE NOT EXISTS
(
SELECT * FROM sys.server_principals AS sp
WHERE sp.sid = db.owner_sid
)
If above returns any rows, try changing the database to a valid login using sp_changedbowner.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1141080017.869972.135450@.j33g2000cwa.googlegr oups.com...
> Installed adventure works..and when creating a database diagram giving
> a message says that it does not have valid owner.
> The adventure works database is in SQL 2005 compatibility mode.
>
|||The above query returns a row.
Tibor, my login is sysadmin fixed server role. I have right clicked on
the database (properties) on the file groyp it says that owner is my
windows domain login.
|||Ok, so if the owner is a valid login, then the problem is somewhere else...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1141137171.049927.50760@.p10g2000cwp.googlegro ups.com...
> The above query returns a row.
> Tibor, my login is sysadmin fixed server role. I have right clicked on
> the database (properties) on the file groyp it says that owner is my
> windows domain login.
>