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 - 2005-09-19 : 07:41:52
|
| Mike writes "Okay, I have 3 servers that have SQL Server 2000 Enterprise Edition installed in a Windows 2000 Server environment where SQL Server was installed with the case-sensitive collation option. One of the servers has 3 instances (local and 2 named instances). The other two just one instance. I have been asked to change these servers from case-sensitive to case insensitive. I have been doing some research and it looks like I can use rebuildm.exe to rebuild the master database, but the user databases are a very different story. The one server that has 3 instances on it has a total 39 user databases divided unequally between the instances. As I understand it to change those databases I have to go down the to the column level to get everything changed. This sounds like s job that borders on insanity for that many databases. The alternative as I understand from my research is to detach the databases, uninstall and reinstall each instance of SQL Server to change to case-insensitive and then reattach the user databases. I am not convinced this will make a difference as the user databases should still be case-sensitive??? This is a long way to go for the question which is - can this be done successfully and if so do you have any suggestions for how it can be done? I appreciate any insights you might have on this. Thanks." |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-09-19 : 09:56:34
|
| uninstall/reinstall sql server with the proper default collation, then re-attach all your databases.-ec |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-09-19 : 17:32:03
|
quote:
Originally posted by eyechart
uninstall/reinstall sql server with the proper default collation, then re-attach all your databases.
The columns would still retain the case-sensitive collation though.???After you fix the server,you will have to somehow recreate the databases with correct collation on all the columns and re-import/insert the data.If the tables are small alter column might do. |
|
|
|
|
|
|
SQL Server 2000 from case-sensitive to case-insensitive