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 |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-09-04 : 05:14:33
|
| hi,i have got installed sql server 2005 in my machine but it is with case sensitive settings.can you explain with screen shots for uninstalling sql server 2005 again and installing it with case insensitive settings |
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-09-04 : 11:13:45
|
| Did you change the default collation settings while installing sql server? I am saying this because the default setting is case insensitive. You don't need to reinstall sql server, just change the collation setting using alter database statement. Hope that helps. |
 |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-04 : 11:39:05
|
| I'd suggest you re-install SQL Server with the case insensitive collation. It will simplify things in future.Do you have any user databases on there? |
|
|
|
|
|
|
sql server 2005 with case sensitive settings