Converting a Case Sensitive database into Case Insensitive (HELP)greenspun.com : LUSENET : SQL Server Database Administration : One Thread
I have sql server already installed and I want to create a dtabase but whenever I create it Its case sensitive. How can I create a case insensitive database without having to reinstall the whole sql server bcz other people have their databases in there too.
-- Anonymous, December 11, 2000
In SQL Server 7.0 this is an attribute of your entire server. In SQL Server 2000, you can have different case sensititity on a per column basis.
Until you can upgrade to SQL Server 2000, I guess you will just have to use the UPPER function a lot.
-- Anonymous, December 23, 2000