Hi

[sravani1227]

This is sravani . I have a doubt .. What is MSSQL server case sensitive and MSSQL server case insensitive . I have to run installation shied on above two combinations of MSSQL server. Is it requires 2 times to instal the MSSQL server software seperately for case sensitive and case insensitive

[dorinbogdan]

Example: If have a Customers table and a record has last_name = "Bob", then:
Select * from customers where last_name = 'bob'
will return that record if it's case-insensitive, otherwise not.

[Akhilesh1505]

This is sravani . I have a doubt .. What is MSSQL server case sensitive and MSSQL server case insensitive . I have to run installation shied on above two combinations of MSSQL server. Is it requires 2 times to instal the MSSQL server software seperately for case sensitive and case insensitive

Hi,
You don't need to install MSSQL server two times intead you have to change
default collation of your databse .
you will use COLLATE SQL_Latin1_Gene ral_CP1_CS_AS to make your search case sensitive.