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

Answers

Mike,

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,

Eric

-- Anonymous, December 23, 2000


Moderation questions? read the FAQ