Menu
When I right click the Tables node in Server Explorer and choose "New Query", rather than seeing the visual designer, I now see a text designer with no obvious way to get to the visual designer (see screen shot).
Notice how the Query Designer tools are all greyed out. Is there any way to get back to the visual designer?
If it makes a difference, the database I'm connecting to is SQL Server 2012 Express.
EDIT
I have done some more research and it appears I should be able to see the designer by just creating a new query (http://msdn.microsoft.com/en-us/library/ms172011.aspx). I can't find any option that may affect this behaviour. It also means I can't just edit a row in my test DB, which is driving me crazy!!!
EDIT 2
OK, the behaviour I get is based on the database I connect to. When I add a connection to an SQL Server 2008 database, right click and choose "New Query" I get the visual designer. When I connection to an SQL Server 2012 database and do exactly the same thing I get the text SQL editor with no access to a visual designer!!!
654
Visual Studio 2010 Shell is installed with SQL Server 2014 and 2012 - SQL Server | Microsoft Learn. This browser is no longer supported. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Open the Query Designer by selecting Query > Design Query in Editor... from the top menu: Selecting the “Design Query in Editor” will get you to the Query Designer.
Access the Visual Query DesignerIn the DataSet Dialog that appears, select the Query page and then select the Edit with visual query designer button . This opens the Visual Query Designer.
While creating the database connection to SQL Server, select the .NET Data Provider as - .NET Framework Data Provider for OLEDB to get the Visual Query Designer in VS 2012 !
171
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
