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,
- 60 = MSSQL 6
- 65 = MSSQL 6.5
- 70 = MSSQL 7
- 80 = MSSQL 2000
- 90 = MSSQL 2005
- 100 = MSSQL 2008
Comment from Anonymous
Time May 27, 2009 at 9:59 am
Did the trick, thanks a bunch!