Thanks for your answer
Yes, I have SQL Server 2000
I already tryed to change the collation type to something case insensitive.
The problem is I have some tables with primary key as char(10) and for
exemple with this content : "Left" and "left". If collation type is case
insensitive then I get key violation when I generate this table.
I need to be able to send SQL with case sensitivity at off and manage the
data with case sensitivity at on. Is there a way to do this?
Thanks in advance
Do you have SQL Server 2000? What is collation identifier
name for your database? To find that execute sp_helpdb
N'YourDatabaseName'. Collation name is in the status
If you have created database without specifying collation,
then your database have default collation
SQL_Latin1_General_CP1_CI_AS, which is Case Insensitive.