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 |
|
catparks
Starting Member
18 Posts |
 Posted - 2002-01-22 : 12:29:09
|
| I have an SQL 2000 server that was installed dictionary order, case sensitive. I need to change it to dictionary order, case insensitive. Is there anyway to change this option without reinstalling SQL Server? |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-01-22 : 12:49:46
|
| Unfortunately i think a re-install is your best option here. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-01-22 : 12:50:51
|
| http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_8w8p.aspYou need to rebuild master if you want to change the server collation settings.You can set different settings for each database and column but will probably be heading for trouble if you tryt that.I would reinstall sql server to be safe as it will probably be as quick.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-22 : 13:38:48
|
| I would rebuild master, it is quicker. Make sure to DTS or BCP any user databases you want to keep to a text file and import it after you rebuildm.Also, if you are on SQL 2000, you will have to copy the source files from the CD, and change the file attributes to not be read-only, or else RebuildM will fail.HTH-Chad |
|
|
|
|
|
|
SQL Case Sensitivity