Results in Grid is not showing in SQL Server

Question

I couldn't see the results in grid pane, so I did the following:

Tools > Options > Query Results > Results to Grid 
      > uncheck the "Discard results after execution" check box

But still I couldn't see the results in grid. I even hit the "Reset to Default" button in same window yet no luck

Please shed some light on this.

Solution 1

Check your default "Results To" selected UI element. Make sure it is selected as "Results To Grid".

I ran into this issue and when I looked at the setting under 'Query Result' > 'SQL server' > it was already set as "Results To Grid"

I believe it was when I was trying hot-keys and fat-fingered CTRL+T which changes the results window to "Results To Text"

Solution 2

Check 'General' tab under 'Query Result' > 'SQL server' to see if the 'Default destination for result' is set to 'Result to Grid'

Comments

[Mar1009]

Tried that too and even restarted SSMS but still not working.

[Andrew]

Anyway, that can be checked more easily with the menu: Query / Results To. If this was the case, I think Mar1009 would have at least said that the results were being shown as text or that he was asked to save a file.

[Mar1009]

I Reset this :options > Keyboard > Reset and restarted it. now worked

[Jay]

After making the update open a new query window, then the updates are working