Property Owner is not available for Database DBNAMEHERE


Your hero for the day!

So during my ongoing mission to protect as well as assassinate all database servers I am responsible for (I will explain how you protect and assassinate at the same time, but later) I ran into the following error when I was attempting to access the properties of some databases through SSMS.

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 rights.  (Microsoft.SqlServer.Smo)…

My first reaction, naturally, was to say “damn.”  After that a quick Google search informed me that this occurs when the original db owner is dropped from the security list (I have a post about orphaned users, or at least I will as soon as I finish this one up).

First run sp_helpdb DATABASENAME and notice the column in the first query table,

owner will = ~~UNKNOWN~~

I would like to point out how I kind of like that they used the squiggly lines ~~~ often used in crude ascii art to denote the money shot, or head shot.

What do you do, the answer is pretty simple, you run:
EXEC sp_changedbowner 'NewOwner'


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.