Property Owner Not Available

I ran across an issue today where I did not have access to the properties on a database.

Even while logged in with administrator I still couldn’t access the properties.

Here was the error:

This blog post helped in fixing it. Running sp_helpdb <dbname> showed that the owner field was NULL. Probably because the old dbowner was removed from Security Logins of the SQL Server.

I ran the following and the issue was fixed.

use <dbname>
go
sp_changedbownder @loginame = 'sa'
go

(Although I’m not really sure why Microsoft decided to spell loginame that way.)