I really love database diagram feature of SQL server. Recently I have installed Sql server 2008 edition and it diagram feature stop work for me. Showing below annoying error although I have dbowner rights.
"Database diagram support objects cannot be installed because thisdatabase does not have a valid owner. To continue, first use the Filespage of the Database Properties dialog box or the ALTER AUTHORIZATIONstatement to set the database owner to a valid login, then add thedatabase diagram support objects."
After doing googling I found solution and it is really simple. Do following steps to enable database diagram.