Posted by serge on 05/21/05 17:13

If I have to send a database to someone and that person can
be using a Case Sensitive or a Case Insensitive SQL Server 2000,
what do I do?

Should i create two databases: 1 CS and 1 CI?

Can't I simply work on 1 CS database all the time and whatever
the person's SQL Server Sensitivity is setup, my database would
work fine? I want to avoid having to have and work on two
databases for this particular purpose.

What happens if someone puts a CS db when their SQL Server
is setup as CI? Would they have a CS db inside a CI SQL Server
environment? Is there a way to convert the CS database to a CI
database by changing the database's properties or something?

Thank you

[Back to original message]