Enable and disable case sensitivity

Hi,

I use a SQL Server 2000.

Is there a chance to change the case sensitivity option for a running instance of sql server?

I know, during the install process, i can activate the case sensitivity. But can I change this option on an already installed server (to case sensitiv or back)?

ThanksYes you can,
this option is called collation. You can set it diferently as default for each database at the same SQL server. Also it can be set for each collumn in each table separately.

Marf.

Originally posted by jenswitte
Hi,

I use a SQL Server 2000.

Is there a chance to change the case sensitivity option for a running instance of sql server?

I know, during the install process, i can activate the case sensitivity. But can I change this option on an already installed server (to case sensitiv or back)?

Thanks|||I think for that you will need to rebuild master ... which is not highly recommended.|||Originally posted by MarF
Yes you can,
this option is called collation. You can set it diferently as default for each database at the same SQL server. Also it can be set for each collumn in each table separately.

Marf.

Thanks! It worked. I changed the collation of a database from case insensitive to case sensitive and back.|||ummmm...huh?