William Doman

Is there a way to mimic the shortcut command CTRL+R that hides and shows the results window in Query Analyzer or Managment Studio after running a querey inside of Visual Stuido 2005 / Database professional tool

Thanks



Re: Visual Studio Team System - Database Professionals CTRL+R

William Doman

I guess I didnt look long enough.

The answer is CTRL+Q.

This seems very odd that it would change. I guess I will have to look into the macros... =)





Re: Visual Studio Team System - Database Professionals CTRL+R

StevenPo - MSFT

William -

I know that in general, we tried to be consistent with the other tools with which you might be familiar. I'll ping the owner on the product team to see if there was a reason why we diverged in this case.

thanks,






Re: Visual Studio Team System - Database Professionals CTRL+R

William Doman

Thanks for the reply.

If you get a chance, ask them why they didnt put the length of time the query ran/runs nor rows returned in the bottom status bar of the results window.

Also, some syntax does not get colored properly. The key word "Disable" for example.

That informations is very important in tuning code, and I now have to buy a stop watch. =)

Is there a better means of reporting / requesting this kind of stuff

Thanks!





Re: Visual Studio Team System - Database Professionals CTRL+R

StevenPo - MSFT

For bugs and feature requests/suggestions, you can enter them at http://connect.microsoft.com. You must log in via Passport to be able to submit bugs/suggestions. If you enter suggestions, be sure to post a link to them in the thread, so other users can see them and go vote on them (the voting helps us prioritize requests for subsequent releases - as you might expect, we will focus more on items that have significant positive votes).

thanks for the feedback. I've pinged the owner for this area, we'll see if we can get her to swing by :).






Re: Visual Studio Team System - Database Professionals CTRL+R

William Doman

I've submitted these features to the Microsoft Connect program. If you would like to see these added please vote for them.

(RowCount) https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=263224

(Query Timer) https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=263220

(CTRL+R) https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=263219

Thanks!!





Re: Visual Studio Team System - Database Professionals CTRL+R

StevenPo - MSFT

William -

As a note, the information that you aren't seeing in the status bar is available in the Properties window when you execute the query. I'd forgotten it was there myself until someone reminded me. So you can save the cost of the stopwatch :).

The team has added the suggestions to the list being considered for the next version of the product.

thanks,






Re: Visual Studio Team System - Database Professionals CTRL+R

Gert Drapers - MSFT

The goal was to be 100% compatible with the Query Analyzer short cuts, needless to say the person who implemented and tested this did not achieve that, mainly because Ctrl+R was already taken in VS for refactoring. In the future it will be configurable, so you can just use your own settings.

-GertD





Re: Visual Studio Team System - Database Professionals CTRL+R

William Doman

I ended up remapped the CTRL+R Key. In the mappings window I didnt have anything bound to the key combination under the SQL Editor screen so it doesnt seem to impact other screens short-cuts.

You can re-map the short-cut.

Tools => Options
Enviorment => Keyboard

Look up the command under "Show commands containing:" Data.ShowHideResultsPane and remove the shortcut of CTRL+Q and the add the shortcut of CTRL+R under (SQL Editor)

You can also use the same screen to look up anything using the shortcut.





Re: Visual Studio Team System - Database Professionals CTRL+R

William Doman

StevenPo - MSFT wrote:

William -

As a note, the information that you aren't seeing in the status bar is available in the Properties window when you execute the query. I'd forgotten it was there myself until someone reminded me. So you can save the cost of the stopwatch Smile.

The team has added the suggestions to the list being considered for the next version of the product.

thanks,

Thank you! That is very helpful. I still hope they put the information in the status bar, the properties window takes up a lot of space.

=)





Re: Visual Studio Team System - Database Professionals CTRL+R

cra451

I tried to vote on this and i could not see a place to do it. It is 'closed'

Chuck






Re: Visual Studio Team System - Database Professionals CTRL+R

William Doman

awe, your right, they are all closed. =(

I hope they really consider them.





Re: Visual Studio Team System - Database Professionals CTRL+R

StevenPo - MSFT

William -

They are still on the active list in our work item tracking database for upcoming Visual Studio Team System releases. I wasn't aware that voting would be closed when a team member responded to the items, but they were reviewed in morning triage (we have a morning meeting where all new issues are reviewed, prioritizied, and assigned to someone), and are still considered "active".

The work for the next major release is still being defined and scoped, so it's too early to have any idea whether it's likely that the suggestions will be incorporated.

let me know if you have additional quesitons.

thanks,