Post reply

F5 Problem

  • March 25, 2011 at 1:44 pm

    #247906

    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!

    My Blog!

  • March 25, 2011 at 3:25 pm

    #1303891

    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

  • April 4, 2011 at 10:58 am

    #1307076

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

    My Blog!

  • April 4, 2011 at 11:05 am

    #1307077

    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

  • April 4, 2011 at 11:15 am

    #1307084

    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. 🙁

    My Blog!

  • April 5, 2011 at 10:41 am

    #1307578

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

  • April 5, 2011 at 10:46 am

    #1307580

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

    My Blog!

  • April 5, 2011 at 11:08 am

    #1307597

    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

  • September 2, 2011 at 10:15 am

    #1376542

    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