I am not sure whether there is any setting like that. It is against
the 'Group By' logic.

John
www.ideo.com

-----Original Message-----
From: Ken Nickels [mailto:[Email Address Removed] November 20, 2002 10:10 AM
To: LazyDBA.com Discussion
Subject: 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.

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page