>I see you have already gotten a lot of good info from Sergey. (What a surprise!) If it were me I would crank up Code References and see how many GROUP BY clauses there are in the application. If it isn't a huge number it might be worth taking the time to fix them rather than ignoring non-compliant SQL code via SET ENGINEBEHAVIOR.

Well, I only see 23 "GROUP BY" clauses, so perhaps it's worth just dealing with them.

I did run across 12 select statements that have "UNION" in them too..grrrrr. I don't like the Union command - seems so touchy to me.