I get the above message when attempting to create a database diagram for advetureworks
Anyone with any clues?
You probably restored the db from somewhere the owner had a different sid. Try:
USE [master];
GO
ALTER AUTHORIZATION ON database::AdventureWorks TO sa;
GO
Many thanks