Database diagram support objects cannot be installed

[Author]

I think a lot of people have this experience.

1) Backup a database.
2) Restore it into a sql server instance (maybe a different one).
3) Click on the Database Diagrams folder in SQL Server Management
Studio and see this:

http://gnewsgroup.googlepages.com/sqlserverdatabasediagramproblem

A solution has been given at:

http://www.mydatabasesupport.com/forums/sqlserver-faq/348914-cannot-create-database-diagrams.html

i.e.:

EXEC sp_dbcmptlevel 'yourDB', '90';
go
ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
go
use [yourDB]
go
EXECUTE AS USER = N'dbo' REVERT
go

It works perfectly. But if I think this is troublesome, is there any
other solution to the problem? Thank you.