Today one of my former colleague said that, while he tried to access the database properties in his MSSQL 2005 database it is showing an error message as below
Initially after reading the message most of us can assume that this error message is appearing due to not having proper access permission. But the real fact is that, because of some reason your database owner is NULL.
To resolve it at first you should check what is the present status of that db by using below command.
sp_helpdb YOURDBNAME
This command will show you the current owner of this database.
To restore this error use the below command
Use YOURDBNAME
exec sp_changedbowner ‘sa’
Now try to open the property window of that database. Hope it will work.
Sayem's Blog 