Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cshah1
Constraint Violating Yak Guru
347 Posts |
 Posted - 2006-02-27 : 10:14:46
|
| 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. |
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2006-02-27 : 12:04:36
|
| What steps are you using to create a database diagram?Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
 |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-02-27 : 13:24:27
|
| Open Management Studio Express tried right clicking on the Database Diagram (Under Adventure Works) and it immediately comes witha pop up says this database does not have a valid owner. I again check my compatibility mode by going to database properties -->options-->It is SQL Server 20005(90) |
|
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-04-04 : 09:15:48
|
| Just an updateI was able to fix this issue a while ago using ALTER AUTHORIZATION ON DATABASE::database_name TO valid_login |
|
|
|
|
|
|
Express - Database Diagram Error