‘group by’ behaviour has changed in ASE v15.x and now follows the ANSI standard (previous ASE versions did not). Indeed the ANSI standard does not sort the output of a ‘group by’ without an ‘order by’. Thanks to traceflag 450, you can revert back this behaviour like it was with previous ASE versions.
1°) At dataserver startup:
Start ASE with -T450 added to the startup script to enable the traceflag for all client sessions.
2°) At session level you can issue:
1> dbcc traceon(450) 2> go
or
1> set switch on 450 with override 2> go
Note: “set switch” is the replacement command for dbcc traceon.
