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!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s