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 - 2001-12-06 : 10:05:58
|
| hawke writes "hi. i have installed SQL 2000 on my Win 2k machine. Unfortunately, i realised i didn't set the 'case sensitive' option which my developers required. is there any way i can set this option on without having to reinstall the software? tks :)" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-06 : 12:45:52
|
| I believe you can do this by running the rebuildm.exe utility, but read up on it first, because you can really mess up stuff if you're not careful. This will require the original install files (CD or network) to be available. It might be better to just do a "clean" install rather than mess with this utility.-------------------It's a SQL thing... |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2001-12-06 : 13:29:28
|
| BTW, if you are on SQL2k you can specify collations when you are creating each databases, so if you create a database with a case-sensitive collation for your developers they will not know the difference. But if you want to set a default case-sensitive collation, then do as Mark says. A word of caution though -- there is a bug in SQL2k's rebuildm utility. A workaround is described in this KB article (Q273572): http://support.microsoft.com/default.aspx?scid=kb;en-us;q273572 |
|
|
|
xiaosha
Starting Member
1 Post |
Posted - 2001-12-11 : 21:20:51
|
| hi AjarnMark and izaltsman. tks for ur help :) |
|
|
|
|
|
|
SQL Configuration