Executing a query in query designer (2008)

Question

I want to be able to execute a query in the query designer window but it is greyed out.

I found this answer on these forums but do not understand the instructions:

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e567754c-eb35-4f70-b05c-79e646cf5744I

It mentions an OPEN TABLE feature which I cant see any where.

I just dont get it.

Can someone explain this to me please?

Answer 1

here are steps http://hodentekhelp.blogspot.com/2008/10/how-do-you-use-query-designer-in-sql.html

---

http://uk.linkedin.com/in/ramjaddu

Answer 2

HOW it is "greyed out"?

And link is broken.

---

www.sqlCMD.ru - all around MS SQL Server

Answer 3

I have already looked at that but it doesn't actually tell me how to execute the query. When you right click on the query the context menu shows Execute as disabled.

Answer 4

If you follow the link in my original question it covers it.

Answer 5

Query desinger is only to generate query - also you must select correct database before start desinger

To execute you have to Press F5 once query genetion completed by desinger. Its does not run on its own (Or on query window press execute button)

---

http://uk.linkedin.com/in/ramjaddu

Answer 6

F5 does not execute a query in the query designer.

You need to leave query designer first. I want to execute within the query designer so that I can use the visual tools to add/remove tables and alter my query. If you follow my first link they explain how to do it but I cant get my head around it.

Answer 7

poppy1, the link you supplied in your original post is broken.  I'm guessing the link you were referring to was a post by Steve Twitchell (here).  His suggestion of using "Open Table" refers to the terminology used by SQL Server 2005 SSMS.  Using the latest tools, it is the same idea, just different wording.  Try this out to see if it makes sense.

1.  In SSMS, right-click on one of the tables you want to use in your query and click "Edit Top 200 Rows"
2.  In the results pane, right click and add Pane -> Diagram (and also Pane -> SQL)
3.  This will give you essentially the Query Designer functionality with the additional benefit of running your queries as you tinker with the designer

Thanks,
Sam Lester (MSFT)

---

This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.