A user had created a database on an SQl server, then when that user left the company,there account was removed from the system, leaving the database with no owner!

When you right click on the database to get the properties, you get the following error:

Cannot show requested dialog.

Additional information:

Cannot show requested dialog. (SqlMgmt)

Property Owner is not available for Database ’[YOURDATABASENAME ]’.  This property may not exist for this object, or may not be retrievable due to insufficient access rights.

(Microsoft.SqlServer.Smo)

 The way to fix this is to assign a new owner by running the following query:

use    YOURDATABASENAME

EXEC    sp_changedbowner “YOUR USERNAME”