1

I would like to create a relationship between to tables. Normally and in previous versions of sql server and the management studio I would go to database diagrams and draw the relation in the diagram.

my ssms 2016 ctp2

I have an 2008 sql server and the ssms 2016 ctp2 client. Am I missing something? tested it too by connecting to an other sql server with other credentials etc.

it is there when I use remote desktop to work on the database server... and connect with a windows account. what am i doing wrong?

He lost me at the 48th second: https://youtu.be/PHjwX-cexIA?t=48s

enter image description here this seems related to https://stackoverflow.com/a/21324448/169714 but what caused the diagram node to disappear when logged in remotely?

Improve this question

1 Answer 1

Reset to default
1

Are you a member of db_owner?

See this:

To use Database Diagram Designer, it must first be set up by a member of the db_owner role to control access to diagrams (https://msdn.microsoft.com/en-us/library/ms189279%28v=SQL.100%29.aspx)

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.