:::: MENU ::::

Database missing owner

Sometimes a database does not have an owner and when you right-click on it and try to choose Properties the GUI just pops up with a message saying that sorry, no, it can’t fullfill your request.

Just open a new query window, use the database and set owner, eg, set owner to sa:
sp_changedbowner 'sa'

And then you can right-click as usual.


So, what do you think ?