Database diagram support objects cannot be installed

By admin - Last updated: Monday, March 30, 2009 - Save & Share - One Comment

When attaching a new database from someone else, you could see an error pop up when trying creating a diagram, it is caused by the dbo of the attaching database doesn’t have a login.

Perform the following steps could resolve the issue,

USE [master]
EXEC sp_dbcmptlevel 'DatabaseName', '90';
ALTER AUTHORIZATION ON DATABASE::"DatabaseName" TO "UserName"
EXECUTE AS USER = N'dbo' REVERT

To check your database compatibility level,

EXEC sys.SP_DBCMPTLEVEL 'DatabaseName'

compatibility level and MSSQL version mapping,




Posted in SQL • Tags: Top Of Page

One Response to “Database diagram support objects cannot be installed”

Comment from Anonymous
Time May 27, 2009 at 9:59 am

Did the trick, thanks a bunch!

Write a comment


Captcha: − three = 6