Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 482
  • Last Modified:

Visual Studio 2012 Query Designer

I`m testing Visual Studio Pro 2012.

In Service Explorer, I right click on tables, then add new query. Query designs fine, then executes fine, but save query is not an option.

Any suggestions on how to save query?
0
Dave_CARSIT
Asked:
Dave_CARSIT
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
don't you have to create a view or Function or Stored Proc from your query?
0
 
Jacques Bourgeois (James Burger)PresidentCommented:
They completely messed up the SQL Server interface in the 2012 Server Explorer. The designers to not have as many features, and Save has been replaced by an Execute (on a right click) that is OK upon creation, but does not work when you try to modify a query.

I now use SQL Server Management Studio for most of my work with databases.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now