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.

All Forums  General SQL Server Forums  New to SQL Server Administration  changing server collation in sql server 2005

Author  Topic  Ronesh Starting Member 33 Posts Posted - 2009-11-08 : 00:20:56 Dear all, I need to change the server collation to Latin1_General_Bin1. In Sql server 2000 there used to be rebuildm exe for this purpose. But i cannot find this in 2005. I have tried a script in command prompt as well.the script to change the collation that i run in command prompt is as under: "start /wait setup.exe INSTANCENAME=<MyServer> REBUILD=SQL_Engine SAPWD=<sapassword> SQLCOLLATION=LATIN1_GENERAL_BIN1" But the message pops up as under: Please go to Control panel to install and configure system components. What to do? I dont want to reinstall sql server 2005 again. Please any one help me to sort it out. Looking forward for the positive response.