August 25, 2008 at 6:50 am
Hello
I am trying to change collation of SQL Server Instance by executing the following command which is given in the BOL from command prompt.
start /wait D:\setup.exe /qn INSTANCENAME=MSSQLSERVER1 REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=PASSWORD SQLCOLLATION=Latin1_General_CI_AS
(Ref: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm)
After that I am getting no error and after 10-15 sec getting prompt again.
Can anybody have any idea why I am not able to change the settings?
I am using SQL SERVER 2005 Enterprise Edition (Evaluation Version).
Thanks in Advance
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 28, 2008 at 12:10 am
I was waiting for the solution but couldn't get single thred 🙁
Is this SQL Server bug or it's working for others?
I have resolved the issue with alternet solution uninstall Database Engine and reinstall with required new Collation.
Thanks 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply