September 18, 2002 at 5:47 am
Dear all,
I have installed SQL Server 7.0 in my machine,by mistake i have installed it as CaseSensitive.Now all the queries in my programs are failing,is there is any way to change CaseSensitive oprion for my database or server.
for Example: If tablename is Employee, if query it as select * from employee this fails.
please anyone help me out
thanks,
sathish
September 18, 2002 at 8:08 am
Bummer.....
You will need to re-install SQL Server to change the case preference, and then reload your database.
Sorry to be the bring you bad news.......
Other option might be to DTS your database to a different server that has a different case preference.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
September 19, 2002 at 7:37 pm
I also think you can change it running from the command line the rebuildm.exe utility.
Here you can change the language, sort order and other stuff with out re installing the server.
September 20, 2002 at 7:27 am
Yes it is true you can use rebuildm.exe to rebuild that master database and all system databases, but then you have to restore your databases from a backup, or reattach them.
Now I've never done this. I know that restoring or reattaching a database from a different character set and sort order it will fail, but here all you are changing is the sort sequence.
Might work! If it does please let me know.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
September 30, 2002 at 12:46 am
How do you activate case-sensitivity in SQL Server 7.0?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply