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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-29 : 07:36:41
|
| yamini writes "Dear friends, Long back I installed SQL server6.5 for my application. that time it was case INsensitive. so all of my programs are like that. Recently I tried to access this sql server from other systems vai JDBC driver. so I modified some settings in my sql server6.5. I am not sure what I did, but I am sure I haven't rebuild any database. From that time onwards it became case sensitive. now I dont know how to make it case NONsensitive. Please some body help me in this situation. It is very important to me. Your help will be greatly appreciated.Thanks & Regards,Yamini_nadella@yahoo.com" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-07-29 : 07:42:02
|
| If I remember correctly, you have to rebuild the master database to change the sort order in SQL 6.5. I cannot imagine it would change spontaneously.Even if you rebuild your master database and make it case insensitive, you won't be able to restore databases which were created with another sort order, so you'll have to import/export those as well.If you run sp_helpsort in isql/w and post it here, maybe we'll be able to help you further. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-29 : 12:38:46
|
| I believe that you will have to reinstall the software and not just rebuild the master database. It has been a couple of years since I used 6.5, but I remember having to do this once.Tara |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-07-29 : 13:26:50
|
| You can chose to only rebuild the master db in the setup program. However, it's quite worthless because user db's will be dropped if you do it, so it amounts to the same thing as reinstalling. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-07-29 : 23:04:08
|
| There is no way it happened spontaneously. You can either rebuild master, or reinstall. Either way, you will need to BCP out your data into a text file, and re import it after recreating your DBs.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
|
|
How to make my SQL SERVER6.5 back to case INsensitive