CODEWITHSUNDEEP
sql-server-2008ssms
MatthewMartin
MatthewMartin

Reputation: 33193

SQL Server Management Studio SSMS tries to "save to file" instead of execute on F5

This happens intermittently and seems to be related to accidentally hitting a key.

Any ideas what causes this?

Upvotes: 166

Views: 61437

Answers (3)

maplemale
maplemale

Reputation: 2046

Previous answer didn't apply to me. My query results were set to grid already (CTRL+D).

The issue is, if you're using a Microsoft ergo keyboard and the function lock (key to the right of F12 usually) is not on, then F5 will bring up an open file dialog by default.

So, yet another embarrassing resolution is: Keep F lock on! :)

On many laptops, there is no dedicated key for this, but often there is a keypress that will be equivalent, such as for dell laptops: Fn+Esc or the All in One Media Keyboard:Fn+Caps Lock

Upvotes: 38

Mark A
Mark A

Reputation: 6171

You can also get stuck in this mode (like I did) by accidentally pushing the "Results to File" button in the toolbar in SSMS. Click the "Results to Text" or "Results to Grid" as desired and you'll be back to your usual, expected behavior.

enter image description here

Upvotes: 3

Saul Dolgin
Saul Dolgin

Reputation: 8814

It sounds like you have accidentally changed from the default query option of "Results to Grid" to "Results to File". If that is the case it is easy to fix:

From the Query Menu -> Results To -> Results To Grid.

OR

Press Ctrl + D

Once you have tried one of the steps above, run your query again by pressing F5.

Upvotes: 308

Related Questions