Group by behavior

Group by behavior

 

  

Hi all

Can anyone recall a switch or undocumented DBCC setting that changes the
behavior of the following in Sql Server?

Column 'so-and-so' is invalid in the select list because it is not contained
in either an aggregate function or the GROUP BY clause.
MS Sql Server LazyDBA home page