Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Results in Grid is not showing in SQL Server

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.

like image 888
Mar1009 Avatar asked Aug 11 '18 14:08

Mar1009


2 Answers

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"

like image 180
JukeSpeets Avatar answered Sep 16 '22 16:09

JukeSpeets


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

like image 25
Afshin Amiri Avatar answered Sep 18 '22 16:09

Afshin Amiri