on 09-08-2010 3:01 AM
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
What problem are you trying to address?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I guess u can change this by changing the server property in SQL Server Management console.
Regards,
Varadhu...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.