Give permission to create database diagram

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