Property Owner Not Available

I ran across an issue today where I did not have access to the properties on a database. I was logged in as an administrator and still couldn’t. Here was the error:Property Owner Not Available

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.)

Advertisements