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)
I am getting this error when trying to 'right click' a properties on the database. Does anyone know how to fix this ?
I've tried following:
use DBNAME
EXEC sp_changedbowner 'myUser'
Getting the following message:
The proposed new database owner is already a user or aliased in the database.
Any Ideas how to fix this ?