Hi all, I got this issue and wonder if anyone knows about it.
As my purpose is to have the indexing as case sensitive, therefore when I installed SQL Server 2000, I chose "Windows Locale Collation" with case-sensitive and accent-sensitive, no binary. The indexing turned out good. However, this case-sensitivity effects on the tables as well. For example, I can create 2 tables "test" and "TEST" which is what I do not want. Is there any way that I can configure the system so that the case-sensitivity is only on the indexing but not the tables?
Cheers