.

Database diagram support objects … error

Database diagram support objects cannot be installed because this database does not have a valid owner.

This sometimes happen when you attach a database from a different machine or after restoring a database from scratch


Solution:

EXEC sp_dbcmptlevel '<<DBNAME>>', '90';
go
ALTER AUTHORIZATION ON DATABASE::<<DBNAME>> TO "<<LOGINNAME>>"
go
use <<DBNAME>>
go
EXECUTE AS USER = N'dbo' REVERT
go

One Response to this post.

  1. Posted by Davide on 07.09.09 at 12:14 pm

    Thank you :) You saved me from the pain

What's your thoughts on this?

*

Protected by WP Anti Spam