I'm having trouble with my Sql Server collation settings.
I need to access my tables in case insensitive mode (sysobjects, SYSOBJECTS, SySoBjEcTs), however the sort of my selects needs to be in an binary order.
I need this for compatibility with reports generated in other database (as Oracle, Sybase, Sybase Anywhere and Informix).

Does anyone know how can I do that?

Using binary sort, the access to the tables turn case sensitive and I have troubles with some few functions.

Best regards,

Fernando David Moyses
Database Administrator