SQL Server 7.0 .How to create Database with BINARY sort order

[csekhar]

SQL Server 7.0

How do I create ( or modify ) a database in sql SERVER 7.0 from "dictionary sort order" to "binary sort order"

Any answers or pointers for resources will be highly appreciated

Thanks


Sekhar

 

[foxdev]

I don't have my v7 docs handy, but IIRC on v7 the sort order was set at the server level, and at install-time. If this is the case, then you can't create a single database with a different sort order. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[Guest_imported]

Hi

thanks for your response. But we brought in a SQL server programmer and he has fixed the issue.

Thanks anyway for sll of your quick response