Post reply

sql server installation

  • July 8, 2010 at 1:47 pm

    #221064

    can we change collation of the instance after the installation is done.

  • July 8, 2010 at 9:14 pm

    #1190589

    You essentially need to re-install SQL Server to change the server collation. You will need to backup all databases that need to be retained.

    Here is a command that worked for me in SQL 2005, you can try it in 2008:

    start /wait setup.exe /q INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=saPassword SQLCOLLATION=Korean_Wansung_CI_AS

    Note: This is similar to rebuild master in SQL 2000- use at your own risk!

  • July 9, 2010 at 12:04 am

    #1190627

    You essentially need to re-install SQL Server to change the server collation. You will need to backup all databases that need to be retained.

    That's true.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply