Fix SSMS Diagramming Errors - 7/7/2016

Here is a very vexing error that is not obvious to fix:

Here is the fix.

Do this statement 1st, including the GO

ALTER AUTHORIZATION ON DATABASE::[my-db] TO "sa"
GO

Then do this one, including the GO

use [my-db]
GO

Lastly, do this statement including the GO

EXECUTE AS USER = N'dbo' REVERT
GO

That did it for me

Blog ID: 2016 Blog_636034464000000000