|
Home > Archive > MS SQL Server > February 2006 > Express 2005 - Database Diagram Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Express 2005 - Database Diagram Error
|
|
| c_shah 2006-02-28, 8:23 pm |
| 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.
| |
| Tibor Karaszi 2006-02-28, 8:23 pm |
| 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.googlegroups.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.
>
| |
| c_shah 2006-02-28, 8:23 pm |
| 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.
| |
|
|
|
|
|