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 |
|
solar
Starting Member
5 Posts |
 Posted - 2006-02-13 : 09:28:39
|
| I attached a SQL express database created on another computer on another SQL express instance running on another computer. When I tried to open a database diagram previously created i receive the following error:"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."I must mention that in the attached database the server login is mapped to the databse as db_owner role. So what's the problem ?Any suggestions ?Thanks |
|
|
solar
Starting Member
5 Posts |
Posted - 2006-02-14 : 07:53:54
|
| I solved this problem. I used alter authorization statement to transfer the ownership of the database to a valid server login.Sorry to bother with stupid questions. |
 |
|
|
|
|
|
cannot open database diagram