Disappearing results pane

• Robert Frasca

  SSCertifiable

  Points: 6027

  More actions

  October 5, 2009 at 7:10 am

  #385504

  When I create a New Query pane and enter a T-SQL query like the one below, I see the Results pane flash but I'm left with only the Messages pane. If I turn on the Execution plan and Client Statistics features, those tabs will also appear but the Results pane does not.

  select count(*) from HumanResources.Employee;

  If I right click the table above and click "Select TOP 1000 rows" it will create a new query pane and I can then execute the query above in that pane without a problem.

  Very strange. Anyone have any thoughts?

  SQL Server 2008, sp 1, build 2531

  "Beliefs" get in the way of learning.

• Robert Frasca

  SSCertifiable

  Points: 6027

  More actions

  October 5, 2009 at 8:19 am

  #1061758

  My bad. I forgot that I had turned on "discard results" last week while testing something else.

  "Beliefs" get in the way of learning.