Make MS SQL Server case-sensitive

I have already install my Microsoft SQL server 2000 as not case
sensitive, how to I change it to be case sensitive?Hi

Check out this previous post

http://tinyurl.com/2qzrv

John

"Dean" <deantakamine@.hotmail.com> wrote in message
news:4563939b.0401091713.3b12169@.posting.google.co m...
> I have already install my Microsoft SQL server 2000 as not case
> sensitive, how to I change it to be case sensitive?|||deantakamine@.hotmail.com (Dean) wrote in message news:<4563939b.0401091713.3b12169@.posting.google.com>...
> I have already install my Microsoft SQL server 2000 as not case
> sensitive, how to I change it to be case sensitive?

Information is in SQL Server books online.

The index is 'case-sensitive instance of SQL Server'.

However, most people are used to the default (case insensitive).