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:40:17
|
| Jun writes "I use the following command to change my SQL server collation. I execute the command successfully without any error. But the server collation is still the old one.I Start the SQL server in Single User Mode. I run “sqlserver.exe -m” to start the sql server from single user mode. Then I run "start /wait setup.exe /qn INSTANCENAME=<instance> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<New SA Password>” SQLCOLLATION=<new collation>"Restart sql server in regular mode, but the collation is still a old one.Is anyone know what is wrong? Thanks a lot for helping." |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-07-21 : 11:13:49
|
| Changing collation only changes collation for 'new' databases.All existing databases + columns have to be amended as a seperate task....there have been code snippets posted here to advise/show how to do this. |
 |
|
|
|
|
|
how to change collation of SQL server?