SQL error message – Property Owner is not available for Database

If you get the “Property Owner is not available for Database” error message when you try to show the properties of a database (right click on a database and click the “properties” menu), you somehow lost the login that is the owner of the database.  It could be the result of a database restore on another SQL server instance where the login is not created. 

Run the following code to see if any owner properties of the database is missing a login

-- check to see if owner is "unknown" for any database
EXEC sp_helpdb

The problem is easy to fix, copy the following code into a new query window, and press CTRL + SHIFT + M to open the template parameter dialog. Enter the databasename and the login you are going to use.

-- fix the problem, press CTRL + SHIFT + M
-- and type your dbname and loginname in the dialog
-- and execute the code
USE <dbname, sysname,>
GO
EXEC sp_changedwowner '<loginname, sysname, sa>'

-- check to see if owner is "unknown" for any database
EXEC sp_helpdb