Engage on Facebook Engage on Twitter Engage on LinkedIn Engage on GitHub

Database Diagram doesn't work in SQL Server 2005????

By Henry Kenuam

I've upgraded several databases recently and every time the Database Diagramming feature doesn't work and I get this error: Database Diagram support objects cannot be installed because this database does not have a valid owner blah blah blah.

And every time I've used ALTER AUTHORIZATION command to try and correct the problem (per the message that your receive). While trying to resolve an unrelated issue I stumbled across the EXEC sp_dbcmptlevel  procedure. This procedure allows you to set dataase compatibility behaviors from earlier version of SQL Server database.  And that did the trick.

EXEC sp_dbcmptlevel 'MyDatabase', '90';

Like magic my Database Diagramming installs and works just fine. For more information you can look at SQL Server documentation here:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/508c686d-2bd4-41ba-8602-48ebca266659.htm


 

Planning a DNN upgrade? Download our guide