Converting a Case Sensitive database into Case Insensitive (HELP) : 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.

Good Luck,


-- Anonymous, December 23, 2000

Moderation questions? read the FAQ