Written by: Girijesh Wednesday, February 25, 2009 12:11:47 PM
If you want to create database diagram using Management Studio, and you are getting error like "database diagram support objects cannot be installed". Execute the following script, just replace the DatabaseName and UserName according to yourself. EXEC sp_dbcmptlevel 'DatabaseName', '90'; go ALTER AUTHORIZATION ON DATABASE::DatabaseName TO UserName go use DatabaseName go EXECUTE AS USER = N'dbo' REVERT go
If you want to create database diagram using Management Studio, and you are getting error like "database diagram support objects cannot be installed".
Execute the following script, just replace the DatabaseName and UserName according to yourself.
EXEC sp_dbcmptlevel 'DatabaseName', '90'; go ALTER AUTHORIZATION ON DATABASE::DatabaseName TO UserName go use DatabaseName go EXECUTE AS USER = N'dbo' REVERT go