question

JLM avatar image
JLM asked

"Diagram Pane" in SQL Server Mgmt Studio GRAY

![I need to use the "Diagram Pane" in SQL Server Mgmt Studio for SQL Server 2012 (it is the ONLY way I can design queries) but it is grayed out and I don't know how to fix it. In the past, I would just return some data from a table by right clicking it and selecting "Select top 100 rows" and then click the "Show Diagram Pane" icon on the toolbar and vioala! But it is grayed out and I don't know how to fix it. (see print-screen)][1] [1]: /storage/temp/2584-diagrammissing.png
viewhelptoolsmanagement studio
diagrammissing.png (157.6 KiB)
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

So is mine. Is that causing any problems? You didn't ask any question.
0 Likes 0 ·
Sorry, my question did not post for some reason. I need to be able to use the Diagram pane. I am a newbie and can only create/edit queries through that graphical interface. In the past I would right click on a table, select top 100 rows and then once the query and results panes appeared I would just click on the show diagram pane and vioala! How can I get the "Show Diagram Pane" icon to be active (not grayed out)?
0 Likes 0 ·
JLM avatar image
JLM answered
Thank you. Yes, that is what I always used to do but I am not getting the "Open Table" option. See image.![alt text][1] [1]: /storage/temp/2586-noopentable.png

noopentable.png (224.2 KiB)
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

If you able to, select the "Edit Top...". this will activate the Query designer options Or from a new query select CTRL+SHIFT+Q
1 Like 1 ·
ThomasRushton avatar image
ThomasRushton answered
How are you attempting to access the tool? Those toolbars will only activate when you're in the right window. To create a query using the design tool, you need to follow the steps here - https://msdn.microsoft.com/en-us/library/ms187937(v=sql.110).aspx * navigate to the table in the database * right-click, and select "Open Table" That should allow you to carry on with the query designer.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi Thomas. I think that should be 'Design' rather than 'Open Table'. (At least that's what SSMS 2014 says.)
0 Likes 0 ·
Actually, Jonlee was right when he said "Edit Top...". *sigh*. Brain not working today - the joys of having a few days off!
0 Likes 0 ·
JLM avatar image
JLM answered
That did it. You rock! Thanks so much.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered
I think you might be confusing the table and query designers. In my SSMS I can right click on a table and select Design. That opens the table designer. If I right click in a query text window I can select Design Query in Editor to load the query editor. These designers make it easy enough to do simple things but anything more complicated just baffles me. I strongly advise you to pick learn the basic SQL syntax if you plan to work with databases. It's pretty simple compared to programming languages. There's a book called Teach Yourself SQL in 10 Minutes, published by SAMS, that will get you up and running really quickly. (The title is a bit misleading. They mean 10 minute chunks, not 10 minutes altogether. I'd love to have a book like that!)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.