cancel
Showing results for 
Search instead for 
Did you mean: 

How can change Case Sensitivity in MS SQL 2008

Former Member
0 Kudos

hi expert,

I want to change Case Sensitivity to Case Insensitivity in MS SQL 2008.

how can I do??

any help please

thanks and regards

jun

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

What problem are you trying to address?

clas_hortien
Active Contributor
0 Kudos

Hello,

there is no way to change this. The SQL Server itself and the SAP Database are installed in an case sensitive collation. If you were albe to change this, your installation will be no longer supported and will, in the worst case, generate incorrect data within the SAP database.

So, start live with it, there is no way to change it.

Best regards

Clas

Former Member
0 Kudos

Hi,

I guess u can change this by changing the server property in SQL Server Management console.

Regards,

Varadhu...

Former Member
0 Kudos

MSSQL database for SAP uses a collation setting which is case sensitive. This is by design and I dont think that collation settings can be changed.