Blog

Most Recent Blog Entries

Apr 7

Written by: hkenuam
4/7/2007 4:08 PM 

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


 

Tags:

Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Add Comment   Cancel 

Purchase

Please click here to buy now.
Payment will be processed via credit card or PayPal.

Test Drive!

Want to find out how it works? Visit our demo site to see the modules in actions!

Subscribe

Sign up for our newsletter and get the latest product updates!

Online Support

Powered by DotNetNuke