Cannot open database properties due to a missing database owner

Problem:

If you try to open database porperties context menu you may face the following error message:

Cannot show requested dialog. (SqlMgmt)
Property Owner is not available for Database '[database name]'.
This property may not exist for this object, or may not be retrievable due to insufficient access rights.


Solution:

1. you can retrieve the configured database owner

use master
sp_helpdb []

2. you can set the database owner

use []
sp_changedbowner  @loginame =  'sa' ,  @map=  remap_alias_flag