Server Explorer is Missing "New Query" options on right click

Question

User349565664 posted

Dear Users,

Please I don't know what I did wrong but after I made a change of settings in my visual studio express preview 2013 i can no longer see the choose "New Query" option in server explorer. Normally ther are several options like open table definition, open table datas, new query and so on , when i right-click on a table in server explorer. 

Can anyone help?

olalakex

Answer 1

User71929859 posted

Hello,

I don't know what I did wrong but after I made a change of settings in my visual studio express preview 2013 i can no longer see the choose "New Query" option in server explorer.

Try by resetting the user settings in visual studio. My below blog post will help you to do that

http://ruchirac.blogspot.com/2012/06/reset-visual-studio-user-settings.html

Answer 2

User-1635195291 posted

Hi olalekex,

Here is your answer:

Microsoft moved some of the Data tools into SQL Server Data Tools (SSDT). That is a separate install, and it comes with a Visual Studio Extension.

Here's a link to another thread on Stack Overflow.

Visual Studio 2012 Database Designer - Am I missing something?

Source: Visual Query Designer not accessible in when connecting to SQL Server 2012 in Visual Studio 2012

Hope this helps.

Thanks,

Jatin