F5 Problem

  • Hi,

    For some reason whenever I press F5 in SQL Server 2008 R2, it is now an Open File shortcut. Is there a way to change it back to just execute the query? [This is really irritating me btw...]

    Thanks in advance!

  • You probably inadvertently hit the Shift+Ctrl+F keyboard shortcut. Happens to me all the time and it drove me crazy until I figured out why that would happen.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • It's still happening... Is there a way to change the F5 shortcut to just execute the query?

  • Pressing F5 does invoke the functionality that "executes the query"...however since you have told SSMS to put the results of the query into a file it has to ask you where to save that file before sending the batch to the server.

    When you have this issue cancel out fo the "Save File" dialog to get back to the query window...then press Ctrl+D to change it back to Grid Results...and then try hitting F5 again.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • Unfortunately, it's not saving the results to a file; it's trying to open a file. I do have the "Results To Grid" enabled and have tried the steps you have suggested, but it's not fixing it. 🙁

  • Do you have a keyboard with an "F-Lock" key? If F-Lock is off, the default for F5 is the open file dialog.

  • YES!!! Thank you everyone for all of your help! Hal is spot-on with my situation. Thank you, thank you!! :w00t:

  • There is another 2 opition

    1." CTRL+E " to execute the query same as F5.

    2." ALT+X " to execute the query same as F5.

    Thanks
    Parthi

  • Hal White (4/5/2011)


    Do you have a keyboard with an "F-Lock" key? If F-Lock is off, the default for F5 is the open file dialog.

    Thank you! This has happened to me before and drove me nuts! Such a simple problem, glad I'm now aware!!:-D

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply