May 5, 2011 at 11:40 am
Hi there
With SQL 2008 database diagram - when I right click on my table to add related tables, this option is greyed out.
I know for a fact the foreign keys do exist, and if I drag a table that I happen to know is related, the relationship lines/joins appear.
Any ideas why this is greyed out?
Regards
Chris
May 5, 2011 at 12:22 pm
Check permissions.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 25, 2018 at 10:53 am
Which permissions should we be looking at? Nothing on google on how to check this or which permission are needed. Thank you.
March 26, 2018 at 8:08 am
danbarroso - Sunday, March 25, 2018 10:53 AMWhich permissions should we be looking at? Nothing on google on how to check this or which permission are needed. Thank you.
It depends. You can grant permissions on the different database diagram stored procedure (all have "diagram" in the name) but when modifying and saving changes to a diagram, permissions are needed to the underlying database object changes as well, such as alter table, etc.
Sue
April 5, 2018 at 7:27 am
Thank you, it turns out my database is a Data Repository database that is copied from a live (production) database and no links/relationship get copied over.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply