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 |
|
Abood
Starting Member
6 Posts |
 Posted - 2009-02-17 : 06:49:55
|
| Hi,i have detached a db from testing enivirment to production. every thing is fine except that i cant display database properties or database diagram.when i click diagram node to display exit diagrams, i receive the following error message:------------------------------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.------------------------------When i click for db Properties, i get the following message:Cannot show requested dialog.------------------------------ADDITIONAL INFORMATION:Cannot show requested dialog. (SqlMgmt)------------------------------Property Owner is not available for Database '[DBNAME]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=Owner&LinkId=20476------------------------------ |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-02-17 : 06:57:16
|
| check your compatibility level. |
 |
|
|
Abood
Starting Member
6 Posts |
Posted - 2009-02-17 : 07:01:39
|
| Thanks,the source and target have the same compatibility level. |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-02-17 : 07:03:12
|
quote:
Originally posted by Abood
Thanks,the source and target have the same compatibility level.
And what is it ?? It should be 90. |
|
|
|
Abood
Starting Member
6 Posts |
Posted - 2009-02-17 : 07:06:04
|
| yes it is. sorry i forgot to mention. |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-02-17 : 07:12:09
|
| Go thru the steps here,http://sqlserver-qa.net/blogs/tools/archive/2007/09/06/error-database-diagram-support-objects-cannot-be-installed-because-this-database-does-not-have-a-valid-owner.aspx |
|
|
|
Abood
Starting Member
6 Posts |
Posted - 2009-02-17 : 07:31:25
|
| Thanks friend, it solve my problem. but why the database lost its owner? i face the same problem when with backup and restore?Thanks again. |
|
|
|
|
|
|
Cant display DB properties or diagram