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.
