April 19, 2011 at 12:09 pm
Hello,
I am trying to check out the properties of one of our database, but couldn't. SSMS shows an error message that states, "Cannot show requested dialog".
The other lines shows, "Property Owner is not available for Database [databasename]. this property may not exist for this object, or may not be retrievable due to insufficient access right."
I have no problems seeing the properties of other databases though, so it's just this one specific database.
Has anyone seen this issue before and found a way to work around this? I appreciate all your help.
Thanks and have a good day.
April 19, 2011 at 12:22 pm
The database owner is invalid. Probably because it was an AD account that has since been removed from AD.
sp_changedbowner and change the owner to sa.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply