October 29th, 2009

SQL Server 2008 – Database Diagram Support

I was pretty frustrated when my diagram was not present when I restord a database of mine in MS SQL Server 2008 Express. The error shown was:

“Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.”

Here comes the solution. Execute the following query on the DB:

EXEC sp_dbcmptlevel ‘yourDB’, ’90′;
go
ALTER AUTHORIZATION ON DATABASE::yourDB TO “yourLogin”
go
use [yourDB]
go
EXECUTE AS USER = N’dbo’ REVERT
go

This solution was posted on numerous sites, but I took it from this blog here.

Related Posts

  1. Microsoft SQL Server 2008 (Express) on Windows 7
  2. How to: Read Kindle books while charging on Vista nd Windows 7
  3. BitDefender Screwed Big Time
  4. Skype 4.1 – back to basics
  5. Starcraft 2 to be released without LAN-play option

Tags: , ,