Fix Permission Issue Creating Diagrams in SQL Server

Today, I was trying to create a diagram in SQL Server to setup table relationships. I kept getting an error. I gave my user owner rights on the database but that still did not work, until I found this:

EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false

This fixed it!


Discover more from dotNetTips.com

Subscribe to get the latest posts sent to your email.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.