Windows Forum

Ask something
Discussion Locked

SQL 2000 sort order?

0 helpful
3 replies

by joncr

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm looking to consolidate 2 servers both running separate SQL 7 applications into one new server running SQL 2000. All is looking fine until we realise that one of the installs of SQL 7 has a different sort order that the other. Is there any way of having one app run one sort order and another app use a different sort order on one SQL 2000 installation?

3 replies

by john

Are you currently writing the apps. Have you tried using direct SQL to change the sort order. What language are they in?

by joncr

I've found that SQL 2000 can run multiple databases with separate sort orders. Thanks anyway.

This discussion is closed to new replies.