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

If you ever get this kind of error, use the following script. Update the script with your database name and login name.


EXEC sp_dbcmptlevel 'userdb', '90';

go

ALTER AUTHORIZATION ON DATABASE::'userdb'TO "userlogin"

go

use ['userdb']

go

EXECUTE AS USER = N'dbo' REVERT

go

Bookmark and Share