Results in Grid is not showing in SQL Server

sql-server sql-server-2012 ssms ssms-2012
Mar1009 picture Mar1009 · Aug 11, 2018 · Viewed 15k times · Source

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.

Answer

JukeSpeets picture JukeSpeets · Jun 27, 2019

Location of UI Button on Sql Server Management Studio Toolbar to change the default query output

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"

Related questions

Recover unsaved SQL query scripts

How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed?

Read More
SQL Server Management Studio won't let me add an index to a table

When I right click on the indexes folder in the table the "New Index" menu item is grayed out. I don't understand why. I've deleted all data in the table just in case, and refreshed and restarted SSMS, but no …

Read More
How to remove cached server names from the Connect to Server dialog?

Or, to put it another way, where is SqlStudio.bin for SQL Server 2012? It doesn't seem to be in the place that would be expected by looking at this other SO question.

Read More