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 - 2006-07-21 : 09:43:55
|
| jun writes "I tried to change my SQL server 2005 collation. I use the following steps. I did not receive any error after I finished all steps. But My SQL server collation are still the old one. I mean the collation of my server did not be changed to the new one that I specified in my command.My steps.1.Start the SQL server in Single User Mode2.Run command “start /wait setup.exe /qn INSTANCENAME=<instance> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<New SA Password>” SQLCOLLATION=<new collation>. 3. Restart the SQL Server Services in regular mode.4. Check the SQL server collation. but the collation is still the old one.anyone know what is wrong? thanks a lot for you help.Jun" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-07-21 : 11:14:10
|
| duplicate...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69443 |
 |
|
|
|
|
|
How to change SQL server 2005 collation