Search code examples
sql-server-2008ssms

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?

Solution

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