Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2008-07-28 : 10:12:44
|
| Hi AllDoes anyone know where I can look to change the server settings to non-case sensitive as referencing many of the fields on our database currently is case sensitive and we want it the other way around (i've inheritated it in it's current state which to be honest is not perfect).Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-28 : 10:17:47
|
| change the collation of databse to use non sensitive collation. use COLLATE clause for doing this in queries. have a look at books online for syntax. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-28 : 23:18:47
|
| Keep in mind that only new objects will use new collation. |
|
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2008-07-29 : 01:24:31
|
| Thanks both, I'll look that up now.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-29 : 03:07:55
|
quote:
Originally posted by Bill_C
Thanks both, I'll look that up now.another quick question (as I'm new to sql server 2005) Where do I look to change the collation of database to use non sensitive collation? and how do I change the setting ? is it just a checkbox or what? Also what about on the server itself? can that be changed (Windows server 2003)Thanks
open object explorer in sql management studio and right click you database and select properties. goto options tab and you have dropdown for collations setting. change it one you want. |
|
|
|
|
|
|
Setting non-case sensitive on sql server 2005